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! Get ahead of the game and start preparing now! Learn more
This must be an easy fix I'm missing. I have a matrix visual with multiple rows. I want to display row totals but only for the top row in the hierarchy. I have +/1 icons off and I do not use a stepped layout. As you can see, I sleect Country, the only row I want a total for, to be the per row level total selection. However, it still totals for all rows. How can I fix this?
For additional context, I'm only trying to get the circled total to remain and remove all the others:
As you can see if I add another row to the end, the totals are still on the lowest row. I am only trying to see row subtotals by country.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 39 | |
| 37 | |
| 29 | |
| 24 |
| User | Count |
|---|---|
| 119 | |
| 100 | |
| 72 | |
| 69 | |
| 65 |