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.
Hello Everyone,
I need a complex conditional formatting in my matrix visual. I hope you can help me, thank you.
Class | Max | 1-May | 1-Jun | 1-Jul | 1-Aug | 1-Sep |
A | 20 | 15 | 18 | 22 | 14 | 19 |
B | 25 | 22 | 30 | 28 | 25 | 19 |
C | 30 | 31 | 28 | 19 | 25 | 35 |
This is my matrix with Class and Max in Rows, Date in Column and number of participants in the Values.
Each class has a maximum capacity. If the number of participants in more than the Max for each Class, the font colour shd be in RED. How can I achieve this?
Thank you for your kind help.
Solved! Go to Solution.
Hi @Emily_Kim ,
You can achive your required output using the color measure like below and using in conjunction with conditional formatting of measures.
I attach an example pbix file.
Hi @Emily_Kim ,
You can achive your required output using the color measure like below and using in conjunction with conditional formatting of measures.
I attach an example pbix file.
Hi @DataNinja777 ,
It works, thank you very much. Really appreciate your kind help.
User | Count |
---|---|
85 | |
84 | |
68 | |
66 | |
55 |
User | Count |
---|---|
126 | |
102 | |
90 | |
84 | |
66 |