Format Matrix Grand Total like Row

[than689]

How can I format the final grand total value like the rest of the row (dark blue, white text)? Is PBI Matrix missing this ability? It seems like it should be a basic function.

Data filtered & context hidden for security reasons

[OwenAuger · Accepted solution]

@than689 

Interesting, it indeed seems harder than it should be to format that specific cell, because it is treated as part of the "Column grand total".

I could only get it working by coming up with some awkward conditional formatting measures and applying them to Totals only:

Total Background Colour = 
IF ( 
    NOT ISINSCOPE ( Account[P&L Level 1] ),
    "#0a3b6f"
)

Total Font Colour = 
IF ( 
    NOT ISINSCOPE ( Account[P&L Level 1] ),
    "#ffffff"
)

PBIX attached.

Does this work for you?

Update: I saw @Uzi2019 's post just appear - so there may be a simpler way.

Regards

[than689]

Thanks - you've certainly managed it! I have a feeling this might be the only way to do this currently...

[Uzi2019]

Hi @than689 

Check the below solution for simpler way.

[Uzi2019]

Hi @than689 
There is option on column Grand total 

You can put same formatting as you have chosen  color for values of table.

Or you can select specific column formatting option

where you can set all values/ header/ total color and background same.

I hope I answered your question!

[than689]

Thanks, unfortunately I don't think this solves the requirement to format only the final value (20,691,462 in your example)