Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower 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):

     

grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
2 months ago

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!