Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, i want to remove columns underligned as red (which are subtotals), i just only want Grand total column (Highlighted with yellow)
Solved! Go to Solution.
Hi @INJAMOV ,
According to your description, here's my solution.
For example there're Year and Month columns in the Columns field of matrix, in the visual formatting pane>Visual>Column subtotals.
1.Turn on the Column subtotals option.
2.Turn on the Per column level option.
3.In the Series option, select the sub-level, here in my sample is Month.
4.Turn off the Show subtotal option.
Get the expected result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @INJAMOV ,
According to your description, here's my solution.
For example there're Year and Month columns in the Columns field of matrix, in the visual formatting pane>Visual>Column subtotals.
1.Turn on the Column subtotals option.
2.Turn on the Per column level option.
3.In the Series option, select the sub-level, here in my sample is Month.
4.Turn off the Show subtotal option.
Get the expected result.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please check https://community.powerbi.com/t5/Desktop/Matrix-How-to-remove-the-grand-total-and-keep-subtotals/m-p...
Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users
This feature is broken. When I set column level to year, it still shows monthly subtotals. As it stands, I can have year & month, or year month & Grand Total, or NO subtotals. In no configuration of these settings can I have year only or grand total only.
But i want excatly reverse, i want to remove sub total and keep grand total
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |