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,
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,
Thanks, it's this:
and the table looks like this:
changing the 0.0% to blank() doesn't make a difference, because all the values in the range are blank() and it seems to work on the logic that if highest and lowest are equal, use the formatting for highest.
As per that example, if I use 0% as minimum, and 100% as max then 0.7%, 1.2%, 1.9% and 2.3% are all low values.