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)

52d8ea85 e988-4c8b-9106-cb66f499a28b 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

e4824350 8e75-4794-8877-bec509b853cb 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.

4ecc8570 1d51-4b40-a5d2-48df0574f8ac 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.

f5478dd2 6629-4fba-a4f3-f861b8b91da7 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.

308d62f8 27f7-4559-a5dd-78a4e1624667 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.

39661f44 7a77-4bdc-9cf2-b015a91747e5 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

7a8131d1 1955-4ac8-af09-10e98213652a 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

056609e5 eb70-41ea-a6f4-fc1e227c164e 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

37118fd1 cd6f-48e6-8aa8-b77d84e0c77a 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

125980fc 7ecf-41fc-8db5-5615dd2c8a7c 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 ?