Conditional Formatting colour below average power BI not working to the rule set

[nmckeown1]

I have created a new rule in conditional formatting for a % Column.  I need to highlight the values that are less than 85% only - so I created a rule and set it have set the rule to colour RED when value > 0% and <=85%. It doesn't allow for just one rule condition i.e Less than 85%. However - its also highlighting some values that are above 85%. See screenshots:

 

[nmckeown1]

This worked perfect - thank you!

[Ritaf1983 · Accepted solution]

Hi @nmckeown1 modify your rule to a number instead of a percent

PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly