Conditional formatting for a matrix with 2 calculation groups

[PabloML]

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

[PabloML]

Is there anyone who can help to solve this topic?

Thanks. 

[Anonymous]

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]

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.