Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Formatting per row on Matrix

Hi, I have a KPI dashboard to make and was wondering if there was a way to have conditional formating per row? Each metric will have different targets and I am trying compare each target to the diffe...
  • speedramps's avatar
    speedramps
    4 years ago

    Hi jostho99

    Please consider this solution and remember I am an unpaid Power BI volunteer, so click the thumbs up button if you like me helping you and the solved button if I fix your problem.

    Click here for an example solution 

     

    This example has the targets in table but you could hard code them in a switch statement.
    A table is better because the users can edit the targets without a PBI developer changing DAX. 


    Create a dax measure like this

    KPI Colour =
    VAR mytarget = SELECTEDVALUE(Facts[Target])
    RETURN
    IF(SUM(Facts[Value])> mytarget, "Red","Green")
     
    Then in conditioinal formating select
    Format Style = Field Value

    What field should we base this on = KPI Colour

     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Hi jostho99

Please consider this solution and remember I am an unpaid Power BI volunteer, so click the thumbs up button if you like me helping you and the solved button if I fix your problem.

Click here for an example solution 

 

This example has the targets in table but you could hard code them in a switch statement.
A table is better because the users can edit the targets without a PBI developer changing DAX. 


Create a dax measure like this

KPI Colour =
VAR mytarget = SELECTEDVALUE(Facts[Target])
RETURN
IF(SUM(Facts[Value])> mytarget, "Red","Green")
 
Then in conditioinal formating select
Format Style = Field Value

What field should we base this on = KPI Colour

 

  • Thamizh_hfhs's avatar
    Thamizh_hfhs
    Icon for Helper I rankHelper I
    3 years ago

    Im assuming the Facts[Value] is a column in the table. What is the Facts[Value] is a measure? How to change the formula?


    I have a similar situtaion where I have a measure "TurnOverRate" and I used the same formula you suggested but my measure is not detectable.