Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Helper IV
3 years ago
Solved

Colour Row Groups in Matrix Visualisation

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
    Anonymous
    3 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Richard_Halsall
      Helper IV
      3 years ago

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        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