Conditional Formatting in Matrix Visual with different conditions based on Row Headers

[Emily_Kim]

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.

[DataNinja777 · Accepted 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.  

[Emily_Kim]

Hi @DataNinja777 ,

It works, thank you very much. Really appreciate your kind help.