Forum Discussion
Conditional formatting for 0 values
I have a conditional formatting based on a measure that basically indicates the variartion respect last month value. It works perfectly well except when this measure is exaclty 0 (no variation respe...
I've just created a simple 'Enter Data' model with 3 rows: -1, 0, 1. I've placed them in a table and used a measure:
Measure Colour = var measureVal = SUM(Example[Measure])
var output = SWITCH (
TRUE,
measureVal > 0, "green",
measureVal < 0, "red",
measureVal = 0, "yellow",
BLANK ()
)
RETURN
outputI've then put those values in a table and got this result:
I can only summize there is some other element at play here that is not found in your description.