Forum Discussion
Conditional Formatting on Percentages - Really?
This really can't be that difficult... I have a simple calculation in DAX, formatted as a percentage, and I want to conditionally format that when 100% Red, 80% Yellow and and so on. I found ...
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
Have you tried the "Color by rules" option? You can put in the decimal equivalents of the percentages as part of the rules and they will work, assuming that your calculation returns a number that you have formatted as % and they are not text.