Forum Discussion

EstherBR's avatar
EstherBR
Icon for Helper III rankHelper III
10 months ago
Solved

Remove grand total from a Matrix

Hi,   I have a the following matrix: I want to have the total per year, but not the grand total. How can I achieve this? There are the settings that I have in the visual:   Thanks! ...
Need Help
  • Tahreem24's avatar
    Tahreem24
    10 months ago

    EstherBR  Workaround is to set the font color of Grand Total to white and for that you could refer the below screenshot:

     

     

     

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

Hi EstherBR ,
You can follow the below steps and it can be achived via dax measures too. 
1. Select your Matrix visual.
2. Go to the Visualizations pane → Format option
3. Expand the Subtotals section.
4 . You’ll see two settings:
4.1 Per row level
4.2 Per column level
--Under Per column level,
5. Turn ON the toggle.
6. Then select the “Column level” dropdown.
7. Choose your Year column.
8. Turn ON subtotal for Year only.
Now, scroll below and turn OFF the general “Column grand total”.

🌟 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!