Greater Houston Texas Power BI Users

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Conditional formatting of a measure based on its value

  • 1.  Conditional formatting of a measure based on its value

    Posted Feb 10, 2021 01:06 PM
      |   view attached
    I am trying to format the background color of a measure "% Goal Complete" but it doesn't let me select the same measure in "Based on field". Is there anyway around it? Any help would be appreciated.

    Thanks
    Murat

    ------------------------------
    Murat Yildirim
    77079
    ------------------------------


  • 2.  RE: Conditional formatting of a measure based on its value

    Posted Feb 22, 2021 04:58 PM
    Hi Murat, it seems the measure is numeric, why don't you use a rule?

    From your screen clip choose rule where you currently have color scale which will allow you to set background color based on values from your measure.

    Regards, Andy

    ------------------------------
    Andy Clark
    CEO
    Houston TX
    ------------------------------