Forum Discussion
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 should range from white (for value zero) to bright red (for max value) as seen below:
The issue is when there are absolutely no alerts (alerts = 0 for all rows, records hence max value = 0) ... the conditional formatting picks the max value color and shows the background color as red, while what was expected was white.
Is there something being done wrong, or is it normal to pick the max value conditional formatting when max & min values are the same?
And any suggestions to better implement this?
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.
6 Replies
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
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.
