Forum Discussion
Conditional Formatting when minimum and maximum are the same
Don't worry about it, I've worked out a way around it for my specific use case. As I'm using percentages which won't go above 100 or below 0 I can hardwire it to this:
You might need to show the whole picture. For me, it works:
Measure = var _suma = SUM('Table'[Number]) RETURN IF(_suma = 0, BLANK(), _suma)Even If I only filter by 0 the number. The blanks always show orange like the rule.
I hope that helps,
Don't worry about it, I've worked out a way around it for my specific use case. As I'm using percentages which won't go above 100 or below 0 I can hardwire it to this:
I've changed the status as this isn't the solution. It works for 0 values, but skews all the others by implying that 100% should be at the top of the divergence and 0% at the bottom. Which means that if the range is only 1%-4% it will show all the values as "good", when I want the top value to show as "bad" irrespective of whether it's 4% or 74%.