Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 5 measures that all use the same scale for for conditional formatting.
The measures are (all %):
I want to use the same formatting scale for each of these
<80% = Red
80-99% = Yellow
99-100% = Green
Is there a way to write a measure that I can use across all of these to get the same formatting?
Currently, I have a formatting measure for each one that looks like this
Hello,
has this been solved?
The only solution I found was to create a separate measure for each item I wanted to format and then select the specific measure for the specific column that I needed to format. If you only have a few columns, it's annoying but not prohibitive. If you have a lot of columns, it will be a beast
Hi, I'm investigating exactly the same issue. Only one measure to be used as conditional field for many measures.
Did you find any solution or workaround in the meanwhile?
thank you.
Marco
Unfortunaely, I've made no headway on this. I spent about an hour duplicating the measure for each thing I wanted to format.
Thanks for your feedback; I'm investigating a way to do it through some C# script. Not yet sure if it's possible or not, but I will let you know.
Hi @aflintdepm
I tried to use calculation groups to deal with this but failed sadly. Not sure if this is possible with calculation groups. Or I don't have enough experience to find a workaround.
Best Regards,
Community Support Team _ Jing
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |