Forum Discussion
Exclude Certain Subtotals From Matrix
Hi Cmcmahan -- thanks for that. Honestly, my table looks a lot less cluttered without subtotals so I may just exclude them entirely. They should really have an easy feature that lets you pick and choose which subtotals you wnat to display!
With your matrix selected, under the Subtotals card you can find the per row / per column settings.
You should be able to use that to accomplish what you are after unless I misunderstood.
jdbuchanan71 Not sure why I don't have that option. I know that I have the latest version of Power BI. Here is what mine looks like:
Could it be because I am using a row hierarchy?
If you turn on "Per row level" what do you see under it?
jdbuchanan71 No, just the option of switching my row value subtotals on.
You will see per row level as an option when your data is grouped in rows and you have row subtotals turned on, and per column level as an option when your data is grouped by columns and you have column subtotals turned on.
I've run into this same issue before. There's no elegant way to solve it. You can read about how I managed to fix it here
Essentially, you have to abuse the fact that PowerBI doesn't actually sum measures in matrix totals, it recalculates them in a different context. Let me know if you have further questions after reading the linked thread.
Hi Cmcmahan -- thanks for that. Honestly, my table looks a lot less cluttered without subtotals so I may just exclude them entirely. They should really have an easy feature that lets you pick and choose which subtotals you wnat to display!
