Forum Discussion
Solved
Conditional formatting not working for custom value = 0
Hi I am trying to implement simple conditional formatting for background color for a field 'Alerts' with the value ranging 0 to Max value (which could be 10 or 200 or any positive integer). The color...
Hi @cyclist007
A workaround below:
creating a measure
adding conditional formatting
Measure 3 = IF(SUM('Table'[alerts])>0,SUM('Table'[alerts]),BLANK())Best regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, please consider Accepting it as the solution to help other members find it more quickly.Thanks @v-juanli-msft for the solution, but then I can't show the count value of '0'.
I'm using another solution for now – using 'Diverging' and then defining it as shown below. But I haven't fully checked if this would break for some reason.
Hi cyclist007
but then i cannot show the count value of '0'.
I don't understand your problem here.
Can you create measure as i shown above?
Best Regards
Maggie
v-juanli-msft Yes I did create the measure but ended up using it as field value also - my bad. Your solution works if i use the measure for conditional formatting only, Thanks!