Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
8 years ago
Solved

Conditional formatting not working properly

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's avatar
    8 years ago

    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!