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 but in Format Visual the options are greyed out. If I apply the below conditions i dont have 2.6% is Red
Please any help
8 Replies
MeTime , Chnage the format to percentage of the field which is being used for conditional formatting.
Hello! 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.
Thanks audreygerred
I try a condition
- 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.
but finally this picture
2,6 % this is a Total i want a colour a red
You're welcome!
For green did you want it to be 0.2% (as stated in original post) which is .002, or do you want it to be 2% which would be .02?
If this solved your issue, please mark as solution.
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()
)
