Power BI

Needs Votes

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

Vote (281)

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)

Power BI User on 05 Jul 2020 23:01:09

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

It would be nice to control the subtotal by value too. Right now, we can only choose by row and column

Kate on 05 Jul 2020 22:57:12

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

This is available now - I just found it hiding under Subtotals > Per Row level.

Michael on 05 Jul 2020 22:56:36

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

Adding my voice too. Totals on one dimension not every single one in a pivot table. Otherwise you triple the row height of your PT.

Kasia on 05 Jul 2020 22:53:03

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

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 changed.

Mud on 05 Jul 2020 22:53:02

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

Agreed. Please provide a method of removing the subtotals from POWERBI Matrix table.

Tim on 05 Jul 2020 22:53:00

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

I agree please provide a way of removing the sub totals

Sreedhar on 05 Jul 2020 22:50:35

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

Option to show sub total is needed. Pls add this functionality

Rajesh on 05 Jul 2020 22:49:27

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

Option to disable Row & column Sub total is very much need. Please provide this functionality

Power BI User on 05 Jul 2020 22:46:17

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

please provide option to disable Row & column Sub total

Power BI User on 05 Jul 2020 22:39:54

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

It would seem a simple fix to add a check box for each Fields, Rows entry, no ?