Conditional Formatting of a measure in a table

[TrentS]

Hi Community,

I have a multi-column table (values and measures) and I am trying to apply conditional font formatting by a rule to one column which is a measure. It works...partially and I can't seem to reason out why. Attached is a snip of the results and the rule conditions. Essentially green for 100%, Yellow for 90-99%, and red below 90%. The measure is formatted as a percentage.

As you can see, it applies the yellow to one value in the range 90-99 but not to the others.

Same thing if I move to icons.

Any thoughts here?Font rules

[Greg_Deckler]

That's pretty odd. Curious what would happen if you based it on decimal numbers instead of Percent, so 1, .90, .99, etc.

[TrentS]

Thanks for the suggestion Greg.

I made the switch to both the measure (decimal number format) as well as changing the rules to decimals and "number". I got the same result as my original.

However!!

As I started switching it back, I changed the measure back to % and they appeared correctly! Note that I did NOT change the rule set from decimals and 'Number"!

Like you said, odd behavior.

Thank you for the response.

[Greg_Deckler]

Ah, potentially mystery solved, it is the percent of the range of your data, so perhaps you have some data that is > 100% essentially? Watch the video here:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-july-2019-feature-summary/#percentRules

[Greg_Deckler]

So weird...