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,
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.