Forum Discussion
Kolumam
Post Prodigy
Post ProdigyConditional 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.
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_BIResponsive Resident
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!