Forum Discussion
Conditional Formatting on Percentages - Really?
Hi Anonymous,
The november's release has this function.
https://powerbi.microsoft.com/pt-br/blog/power-bi-desktop-november-2017-feature-summary/
You just should use 1 to red, 0.8 to yellow and so on (assuming your measure is formatted as percentage).
Ricardo
I have tried this several ways...I have a column that calculates a percentage based on two other columns. The max it can be is 100%, and that (for better or worse - I didn't pick it) is the goal, and that's what they want to have "green." However, I have tried it using rules, setting yellow to less than 1 and green to "is" 1 (I also tried >= 1), and it stays yellow. If I back the 1 down to 0.93, it will turn green, but as soon as I put in a number larger than that, it goes back to yellow. Any ideas?