Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |