Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Conditional Formatting

Is it possible to use conditional formatting but base the format on a selection of a filter? I have a measure that I want to display as red when over the value of 120. However, this 120 is monthly. ...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous you can create measure to return the color and then use that in conditional formatting

 

KPI Color =
VAR __value = SUM( Table[Amount] )
VAR __limit = 
IF( HASONEVALUE( Table[Month] ), 120, 1440 )
RETURN
IF( __value > __limit, "RED" )

Now use this measure in conditional formatting. Change above measure as per you data set