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.
Perhaps enter a Highest Value of 1 or something like that?
Greg_Deckler wrote:Perhaps enter a Highest Value of 1 or something like that?
That would not allow for agradient background color ... maybe 1 alert is not as bad as 10 so i would like to show the gradient which is determined by the max value.