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,
Hi mcumis
You can manually control the colors by switching from "By color scale" to "By rules" in Conditional Formatting. Step-by-step fix using Rules:
1. Click on the visual where you want to apply Conditional Formatting.
2. Go to the Format pane >> Data colors >> turn on Conditional formatting.
3. Change the format type from Color scale to Rules.
4. Add a rule like this:
If value is = 0, then use the desired Minimum color (e.g., light gray or white).
You can also define other rules if needed, like > 0 for a different color.
or
If you want to suppress zeros visually and only color when there's meaningful data, modify your measure like this:
New Measure = IF([YourMeasure] = 0, BLANK(), [YourMeasure])