Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet 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!
| User | Count |
|---|---|
| 97 | |
| 73 | |
| 50 | |
| 46 | |
| 44 |