Conditional Formatting on Percentages - Really?

[Anonymous]

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 some information in the community - but nothing particularly helpful.

[guanel1]

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. 

[Anonymous]

I am having the same problem.I have a measure which is a calculated percentage of other two column.Any ideas on how i can work this out

[ripstaur]

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? 

[Greg_Deckler]

Hmm, I actually just tried this and I'm not getting conditional formatting to work with measures, only columns...

[Anonymous]

I too can only use this function on columns and not measures.  Are measures not supported for conditional formatting??

[Greg_Deckler]

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.

[ricardocamargos · Accepted solution]

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