Formatting Matrix Visuals

[ArchStanton]

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 matter what I try I can get it to work, so, its just the 6452 figure that requires the background colour. The Style Preset is called 'Minimal'. 

Unfortunately, I cannot share my pbix file.

[Lodha_Jaydeep]

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.

[OwenAuger · Accepted solution]

@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):

[grazitti_sapna]

Hi @ArchStanton,

It should work with grand total as well, but if it is not working as a alternate you can create a new measure as Total = Measure1+Measure2+measure3 and use it in the MATRIX view table. IT should fix the issue which you are facing.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!