Power BI

Needs Votes

Please provide a way to enable/disable Subtotals for columns for matrix visualization

Vote (223)

Alexandre Durocher on 29 Mar 2016 02:42:48

As in Excel, it would be nice to be able to add or remove subtotals by column for Matrix Visualization instead of having either totals for all columns or none.

Comments (34)

Comments (34)

9724ae65 1c0e-4f9c-a9fd-0ef6762c7d2a on 05 Jul 2020 23:40:22

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

Need to be able to show grand total independent of sub totals

4b8ff8e2 9c5a-4528-aef7-3aaa6c37611e on 05 Jul 2020 23:40:00

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

It will be a good idea to have this actually do it both ways. A way to just show grand totals and not sub totals and a way to show sub totals and not grand totals.

b70a36b5 a2f6-4d9f-b34d-c90e323fc82a on 05 Jul 2020 23:38:51

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

It would be a desirable feature to disable the subtotals for some columns in Matrix visualization. I wonder why it cant be done in Power BI yet when other reporting tools like Birst have it.

722f7dc8 bc00-4352-8cb7-8adeee5ae115 on 05 Jul 2020 23:38:33

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

We would like this feature implemented. Please add this into Power BI

a5dd96a4 eda3-4f8f-816b-695d463fe392 on 05 Jul 2020 23:38:29

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

Please make these independent.

6ebdf35a 8c01-4944-8b4b-bb13ab4a1ea8 on 05 Jul 2020 23:36:23

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

I support this suggestion! At this point for example, I need to disable a subtotal of a column that contains text and I can not.

138dad26 ee1c-4125-be6a-f78c008b9d95 on 05 Jul 2020 23:30:00

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

It would be great to be able to turn Grand Totals and/or subtotals on or off independent of each other.

06c424dc 0042-4022-9968-b55f5458345a on 05 Jul 2020 23:17:37

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

I think this would be very useful as there are numerous instances where it makes business sense to subtotal some of the columns in a given row, but not all. Also if the column happens to be tests vs. a number, current option is to select first, last, count etc. For text fields many times I just want to show nothing in the subtotal for that row.

c1dd7533 8ecc-4e6b-b6e2-8c44850a51f1 on 05 Jul 2020 23:02:51

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

When you have groups and subgroups, in my data, there are cases where there is only 1 subgroup to a group. In that case, the subtotal is redundant and takes up (sometimes) valuable screen space.

Would love for that to be the automatic behavior. Or at least be an option, like many of the other column parameters.

5d190a5b 4c28-4453-bf10-cf6372fdca5a on 05 Jul 2020 23:01:11

RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

'@Kate, this is not already available as the current option allows all or none but now a fine level of control like in Excel Pivot Tables. We need the option to choose which subtitles are shows and which are not.