Conditional formatting not working for custom value = 0

[cyclist007]

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?

[v-juanli-msft · Accepted solution]

Hi @cyclist007

A workaround below:

creating a measure

adding conditional formatting

Measure 3 = IF(SUM('Table'[alerts])>0,SUM('Table'[alerts]),BLANK())

Best regards
Maggie

Community Support Team _ Maggie Li
If this post helps, please consider Accepting it as the solution to help other members find it more quickly.

[v-juanli-msft · Accepted solution]

Hi @cyclist007

A workaround below:

creating a measure

adding conditional formatting

Measure 3 = IF(SUM('Table'[alerts])>0,SUM('Table'[alerts]),BLANK())

Best regards
Maggie

Community Support Team _ Maggie Li
If this post helps, please consider Accepting it as the solution to help other members find it more quickly.

[cyclist007 · Accepted solution]

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.

[v-juanli-msft]

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

[cyclist007]

@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!

[Greg_Deckler]

Perhaps enter a Highest Value of 1 or something like that?

[cyclist007]

---

@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.