Forum Discussion
Conditional Formatting with Switch and Selected Measure or Value
Hello, I have a ton of measures in cards and want to color code them. The color coding rule is always the same. Problem is, how can I apply it to all of my different measures. Since it would ...
*bump* Did anyone find a solution to this?
If I replace SELECTEDMEASURE() with the one of the actual measures it works; but Microsoft shows this as an example on how to use the SELECTEDMEASURE() function, so I guess this should work??
https://learn.microsoft.com/en-us/dax/selectedmeasure-function-dax
I have the measure below on conditional formatting; but it is returning both positive as negative values in green.
MeasureColor =
SWITCH(
TRUE(),
SELECTEDMEASURE() < 0, "Red",
SELECTEDMEASURE() >= 0, "Green"
)
Hi , unfortunately this doesn't work for the case above . I haven't found a solution yet.