Forum Discussion
condional formating
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.
Hai
To condition follow a orginal post but i try a condition color do not match in rules, i want to try your give solution that result all persentase its red colour
is there any solution?
Thank You
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()
)
