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.

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

[bpn1973]

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