Forum Discussion
conditional Formatting based on other measures
Hi everyone, I am looking to conditional format a card dependent on another different measure and have that conditional formatting change dependent on the slicers. My slicer is for the teams ...
Hi Anonymous ,
I went ahead and created a little data set in excel:
I created a slicer for team
Then I created a measure:
Conditonal Format Flag = if(max(Sheet1[Target])>max(Sheet1[COB]),1,-1)
Then going under the card visualization, select > Format>Data Label>the little elipses by Color>Condtional Formatting.From thereFormat by: RulesBased on field: Condtional Format FlagRules:If values is 1 then Red (under target)If value is -1 then Green (on or over target)Hope this helps!Caleb Foster
Hi Anonymous ,
I went ahead and created a little data set in excel:
I created a slicer for team
Then I created a measure:
Conditonal Format Flag = if(max(Sheet1[Target])>max(Sheet1[COB]),1,-1)
Then going under the card visualization, select > Format>Data Label>the little elipses by Color>Condtional Formatting.
Then going under the card visualization, select > Format>Data Label>the little elipses by Color>Condtional Formatting.
From there
Format by: Rules
Based on field: Condtional Format Flag
Rules:
If values is 1 then Red (under target)
If value is -1 then Green (on or over target)
Hope this helps!
Caleb Foster
It worked! Thanks for the help :)