This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreGet Fabric Certified for FREE during AI Skills Fest. This week only. Secure your voucher now.
Any ideas on how to remove the subtotals and grand totals for these two columns (don't need) when in collapse mode?
I have subtotals currently set to:
Which is perfect in expand mode:
But in collapse mode it shows (first screen). Thanks
Hi@smc,
You may use the drill down function in Martrix to achieve your needs by clicking on this icon on the visual.
If you want to display the data more visually, you can also change the visual and use the table visual.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi and thanks but unfortunately did not work:
Hey @smc ,
sadly you cannot change that setting dynamically.
So either you can turn it on or off, but there is no possibility to dynamically turn it on or off.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 25 | |
| 24 | |
| 22 | |
| 21 | |
| 19 |
| User | Count |
|---|---|
| 52 | |
| 48 | |
| 47 | |
| 22 | |
| 21 |