Colour Row Groups in Matrix Visualisation

[Richard_Halsall]

Hi

I have a matrix visualisation where I have selected the option 'Switch values to row groups ' which looks like this:

I need to be able to colour the row groups differently. I know it is possible using a measure and conditional formatting to colour rows but can it be done for row groups?

Thanks

[Anonymous · Accepted solution]

Hi @Richard_Halsall ,

As far as I know, the calculation in Power BI will base on columns. However, [TRIR] and [Target] are from different columns. So we need to set the conditional formatting for each column/measure.

In my sample, I set [TRIR] show blue and [Target] show orange by Field value in Background conditional formatting.

Color for Target = "Orange" 

Color for TRIR = "Blue"

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Richard_Halsall ,

As far as I know, the calculation in Power BI will base on columns. However, [TRIR] and [Target] are from different columns. So we need to set the conditional formatting for each column/measure.

In my sample, I set [TRIR] show blue and [Target] show orange by Field value in Background conditional formatting.

Color for Target = "Orange" 

Color for TRIR = "Blue"

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Richard_Halsall]

Hi @Anonymous , I did manage to do this also I was trying to get the labels TRIR & Target to be coloured as well Thanks

[Anonymous · Accepted solution]

Hi @Richard_Halsall ,

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your issue or share me with your pbix file without sensitive data.

Best Regards,

Rico Zhou