Conditional Formatting

[Anonymous]

I have copied the matrix table from one report to another, then changed the source BUT the conditional Formatting is not working correctly

Required Greater Than 95% colour should be Green, less than 95% should be red (although Power BI does not do red very well)

First Matrix (New month February) does not continue Formatting

The second Matrix is wrong completely

Conditional Formating 

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Try defining your conditional formatting on a scale of 0 to 1 like Minimun=0, Maximum=0.95

Check if this works.

Thanks,

Pragati

[Anonymous]

Thanks for such a quick answer 0.95 did not work, gave the wrong results completly

BUT

9.5 as the higher works like a treat, thank you so much for the guidance and putting me on the right track

[Pragati11]

Hi @Anonymous ,

This could be due to the data formatting of your percentage field. But nice that you found the solution.

Thanks,

Pragati

[Anonymous]

How do I check the data formatting of the percentage field?

[Pragati11]

Hi @Anonymous ,

Check the following screenshot:

Thanks,

Pragati