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,
Thanks, that might be so, but converting 0 to blank() via the IF statement wasn't solving the issue. It cleared out the values but still formatted to the maximum colour (perhaps because the MAX values overrides everything, even blanks?).
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,
This did work, I must have made a mistake yesterday. Thanks for taking the time to reply.
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.