Conditional Formatting with Switch and Selected Measure or Value

[raymondpocher]

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.

[Smis]

*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"

    )

[poli361]

Hi , unfortunately this doesn't work for the case above . I haven't found a solution yet.

[GG23]

Have you found a solution for this? I'm needing the same. Thanks

[tavolo89]

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.

[Anonymous]

I'm struggling with the same problem.
Did u find a workaround?
Calculation item measure cant be applied btw.

but the measure is greyed out when trying to use it as condition

[raymondpocher]

@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?

[amitchandak]

@raymondpocher , as far as I know, you have to create it from tabular editor only.

Appreciate your logic. Good Idea to reduce measures.

[raymondpocher]

Thanks but seriously? 😄