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!
I want to have a matrix table on my PowerBI report. I have 13 periods and I am comparing two sets of numbers. For one set, I would like to have the total column. I don't want it to show the totals per each period. Is there a way to do this? Thanks
@Anonymous , Not very clear, but you can use per row/column level to disable the subtotals
refer: Power BI how to show/hide subtotal, grand total| Matrix Per Row Level- https://youtube.com/shorts/kVmQxecQ-BY
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 |
|---|---|
| 69 | |
| 44 | |
| 34 | |
| 28 | |
| 23 |
| User | Count |
|---|---|
| 142 | |
| 121 | |
| 59 | |
| 40 | |
| 32 |