Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Conditional formatting based on a dynamic value (slicer)

Hi guys,   so, basically every time I change my slicer, a new value is calculated (measure - it´s an avarage)   how do I make a conditional formatting based on this value that changes when I clic...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous you can create another measure for KPI Color based on your mesure

 

for example

 

KPI Color = IF( [Measure] > 1, "Red", "Green" )

and now you can use this KPI Color  measure on conditional formatting and color will change based on your original measure.