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. 

 

Need Help
Show and Tell
  • JoHo_BI's avatar
    JoHo_BI
    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!

1 Reply

  • JoHo_BI's avatar
    JoHo_BI
    Responsive Resident
    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!