Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @cyclist007
A workaround below:
creating a measure
adding conditional formatting
Measure 3 = IF(SUM('Table'[alerts])>0,SUM('Table'[alerts]),BLANK())
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
A workaround below:
creating a measure
adding conditional formatting
Measure 3 = IF(SUM('Table'[alerts])>0,SUM('Table'[alerts]),BLANK())
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |