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
So, i just ran into this myself - and what i needed to do is pay attention to how the data is displayed. My percentage in the table is not calculated (listed as "Dont Summarize"). But when I went into the Conditional Formatting popup it was showing the following:
the Count of % was not working. I had to update this to Maximum - then the calculations were displaying correctly.
So pay attention to how the conditional formatting is trying to read the dataset for your percentages.