Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Dear fox,
Can the grand-total row be removed without removing the sub-totals? There seems to be an option in the format tab, but it's not working when sub-totals are on.
Thanks in advance.
Hello @Shimon_Amir ,
Check if this solution works for your case https://community.powerbi.com/t5/Desktop/Matrix-Remove-column-Grand-Total-but-keep-Sub-Total/m-p/272...
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 41 | |
| 21 | |
| 21 |
| User | Count |
|---|---|
| 150 | |
| 107 | |
| 64 | |
| 36 | |
| 36 |