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

OwenAuger's avatar
OwenAuger
Super User
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

  • than689's avatar
    than689
    Helper I
    2 years ago

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

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi than689 

      Check the below solution for simpler way.