Forum Discussion
condional formating
I have a Rules with percetage format. So in card it gives a certain percentage value. I want to apply conditional formatting where if > 2,4% "Red" and >=2.0% and 2.4% "Yellow", 0% and 0.2%= Green b...
audreygerred
Super User
Super UserHello! Based on what you have in your screenshot, 0 to less than 20% is green, 20% to less than 24% is yellow and 25% to 100% is red, so in this case 2.6% would fall in the green area (also, since the yellow rule has the upper limit as <24% and the red rule is >=25%, anything from 24% to less than 25% won't be colored.
- For green, change .2 to .002 (.2%)
- For yellow, change .2 to .02 (2%) and. 24 to .024 (2.4%)
- For red, change .25 to .024 and you can leave the 1 alone as long as you'll never have over 100% as a value. Otherwise, make 1 be 10 just to be on the safe side.
For this scenario you can use dax function, In power bi desktop go to the model view, and then create a new custom measure using DAX.
Card_Color =
VAR YourValue = [YourPercentageMeasure]
RETURN
SWITCH(
TRUE(),
YourValue > 0.024, "Red",
YourValue >= 0.020 && YourValue <= 0.024, "Yellow",
YourValue >= 0 && YourValue <= 0.002, "Green",
BLANK()
)