Forum Discussion
Exclude Certain Subtotals From Matrix
I am creating a table using a matrix visualization in Power BI. I have row subtotals onsince certain columns in my table make sense with subtotals but there are some column subtotals that I would like to exclude entirely. Not only do they not make sense, but it is simply repetitive. If I try to exclude one of the values (in the row hierarchy), the entire column disappears. If I try to exclude the total value of the row hierarchy, the entire section of the hierarchy disappears.
Is there a way for me to only show certain subtotals from my matrix? Ideally, I would like to exclude subtotals (or averages) from a few columns without making subtotals disappear entirely.
The links below tell me that I am able to turn on and customize "column subtotals." However, I have just updated Power BI to the latest version and I do not see that as an option under Format > Subtotals. My only option is row subtotals.
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!
7 Replies
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?
