Skip to main content
Microsoft Idea

Power BI

Needs Votes

Show/Not Show Subtotals

Vote (84) Share
's profile image

on 17 Feb 2017 03:34:49

I would like to be able to choose whether or not i want to see subtotals in a table or matrix, to be able to turn them on or off. I know you can do this with totals under general but sometimes i want the grand total but not subtotals.

Administrator on 21 Jul 2021 16:49:05

Row and column subtotals can be toggled on or off within the format settings.

Comments (3)
's profile image Profile Picture

Kasia on 16 Aug 2020 03:57:59

RE: Show/Not Show Subtotals

This is a must to decide which of dimensions should have subtotals and which not. Right now you can only have subtotals for all dims, or any of it = grand total for the column/row is not available too. This should be fixed.

's profile image Profile Picture

James on 16 Aug 2020 03:56:30

RE: Show/Not Show Subtotals

I would like the ability to fully customize any report that is made. Being forced to see sub-totals/grand totals is something that hinders this ability.

's profile image Profile Picture

Power BI User on 16 Aug 2020 03:56:24

RE: Show/Not Show Subtotals

I would like a variety; the choice to choose to have subtotals, but not a grand total, or a grand total, but no subtotals. This feature is critical for the types of reports that we are building at our organization.