Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 months ago
Solved

Formatting Matrix Visuals

I'm stuggling to format the visial below where I am tring to get the Grand Total highlighted in the same 'blueish' colour that the total and headers have.   This should be straightforward but no m...
Need Help
Show and Tell
  • OwenAuger's avatar
    OwenAuger
    2 months ago

    ArchStanton 

    Yes, it does seem impossible to change just the Grand Total cell's background colour, since the Row Grand Total formatting doesn't apply to that cell and Column Grand Total formatting applies to the entire total column!

     

    One workaround would be to create an appropriate visual calculation that returns the desired background colour for cells in the Total row, and apply that using conditional formatting. In your case this might look like:

    Background colour = 
IF (
    NOT ISATLEVEL ( [Age Profile] ),
    "#D2DFE6"
)

    Here's an example using a Contoso dataset (attached):

     

Lodha_Jaydeep's avatar
Lodha_Jaydeep
Solution Sage
2 months ago

Hi ArchStanton, 

 

You can do this in the below format.

 

1)  create one measure as below. update your table and column names.

Grand Total BG = 
VAR RowTotal = NOT ISINSCOPE(SalesMatrix[Age Profile])
VAR ColTotal = NOT ISINSCOPE(SalesMatrix[Category])
RETURN
IF(RowTotal && ColTotal, 1, BLANK())

 

2) matrix visual setup

 

3) keep BG colur formatting for the Rows and Colunms as follows, you can use total only also.


You are good to go. Let me know if you find any issues.

Hope this helps give some kudos and mark as accepted solution if help or give some kudos.