Forum Discussion
Kolumam
8 years agoPost Prodigy
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.
- 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!
JoHo_BI
8 years agoResponsive 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!