Matrix Formatting: Column Grand Total format to match Row Format

[SokMunki]

Hi all! I've got a Matrix that looks like this (color scheme is a work-in-progress):

The last column is the Grand Total column, and I'd like for the background to match the row color so it's a bit easier to read which total aligns with which column. As you expand/collapse the rows the expanded Grand Total backgrounds should match the expanded row backgrounds.

Is this doable?

Thanks in advance!

[than689]

Hi @SokMunki , did you find a way to achieve this? I've a similar requirement and just created a post for it.

[amitchandak]

@SokMunki , I think Specific column or conditional formatting with Grand total can help

Conditional formatting with gt

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...