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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello everyone,
I want to hide the sum in the matrix for some values. How does it work?
This is my starting matrix with rows A, B
This is what I want as a result
For text fields and datefields I don't want any output in the total line.
If it doesn't work that you hide them, then it would be good if you at least put a blank there.

Thank you for help
Under format visual, go to column or row subtotals and check per row level. Then use the dropdown on Row / Column level to select which rows / columns you want to hide from totals.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!