Forum Discussion
Solved
Conditional Formatting when minimum and maximum are the same
I'm using the following Conditional Formatting colour scheme, but and I want greater control over what happens when the values are the same (in this instance, zero). As all the values are 0, I want ...
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,
Neither of these work for what I want to do. It's not a simple "0 = blue" and ">0 = red" question. I want a lowest to mid to highest gradient to apply, where the mid and high are not a threshold but relative. (As the gradient functionality does.)
Also as I said in my post, I tried wrapping it in IF and swapping 0 for blank() and it didn't work.