Forum Discussion

than689's avatar
than689
Helper I
2 years ago
Solved

Format Matrix Grand Total like Row

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...
Need Help
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    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

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

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's avatar
    than689
    Helper I
    2 years ago

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