Conditional formatting not working properly

[Kolumam]

Hi Power BI,

When I try to add condition formatting to numbers, it doesn't assign the colours properly. Please see the below screenshots. 

[JoHo_BI · Accepted solution]

Hi Kolumam, 

You're basing the conditional formatting based on a count of the number of occurences, like the number is treated as a text value. 

Try changing the data type to a number, or the summarization to average.

Hope that helps!