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, 0 value isn't empty, it's the output of this measure:
I've tried various versions of this (" ", "", blank()) but none worked:
Just for the heads up. An empty in dax is a BLANK(). IF it wasn't working maybe it would be a matter of debuging the result of the division.
I'm glad you found a solution.
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.