Forum Discussion

PabloML's avatar
PabloML
Regular Visitor
2 years ago

Conditional formatting for a matrix with 2 calculation groups

Dear all,

 

I have created a matrix with 2 calculation groups. In Rows I have a calculation group for every KPI, and then in columns I use the other calculation group for different measures (like YTD, VLM, etc.).

 

I wonder if it's possible to set up a conditional formatting, I just need change the background color of the whole row for a specific KPI, with a matrix with 2 calculation groups.

 

Many thanks for your time.

 

BR

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi PabloML ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

     

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • PabloML's avatar
      PabloML
      Regular Visitor
      2 years ago

      Thanks, Anonymous for this.

       

      Well, right now I have something like this:

       

      And I'm looking to have something like this:

      The matrix contains 35 KPIs and there are 5 "major" KPIs that I don't show any value but I want to color the background on the entire row as you can see in the second image.

       

      Hope someone can give me a tip on how achieve this.

       

      Thanks for your time.

  • PabloML's avatar
    PabloML
    Regular Visitor
    2 years ago

    Is there anyone who can help to solve this topic?

     

    Thanks.