Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
*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.
Hi , unfortunately this doesn't work for the case above . I haven't found a solution yet.
Have you found a solution for this? I'm needing the same. Thanks
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.
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
@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?
@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? 😄
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |