Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
raymondpocher
Advocate III
Advocate III

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.

6 REPLIES 6
GG23
New Member

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

tavolo89
Frequent Visitor

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
Not applicable

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

bpn1973_0-1644183948162.png

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

bpn1973_1-1644184020941.png

 

 

raymondpocher
Advocate III
Advocate III

@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
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.