Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |