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 be ridiculous to manually define each color condition I am looking for way to do that all at once.
I was super excited to use the selected measure function of dax...but it wasn't working. Can anyone help?
Sample Color Coding Background =
SWITCH(
TRUE(),
SELECTEDMEASURE() < 0.8, "#E34858",
SELECTEDMEASURE() < 0.95, "#EB6F24",
SELECTEDMEASURE() > 0.95, "#2EA675"
)
And I cant use Tabular Editor since it is blocked from our IT.
8 Replies
raymondpocher , as far as I know, you have to create it from tabular editor only.
Appreciate your logic. Good Idea to reduce measures.
Thanks but seriously? 😄
amitchandak : do you know if there is a free version? Or do you have any experience on that regarding licensing. Would only the person that creates the report need a tabular license or anyone who views a report?
Did you ever find an answer to this? I'm trying to do the same via Tabular Editor using SELECTEDMEASURE() but it does nothing for the font colour.
Have you found a solution for this? I'm needing the same. Thanks
*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-daxI 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.
