Skip to main content
Microsoft Idea

Power BI

Needs Votes

subtotals for matrix

Vote (138) Share
Power BI User's profile image

Power BI User on 25 Sep 2015 03:20:25

ablility to select sub totals for the matrix

Comments (13)
Power BI User's profile image Profile Picture

Pieter van der Zijpp on 03 Feb 2023 10:28:47

RE: subtotals for matrix

Seems bizar to me that this basic feature is not in the matrix visual: formatting subtotals to include the value of which they are showing the subtotal.Examples: Total EBITDA, Total Gross Margin, Total OPEX, etcetera.

Power BI User's profile image Profile Picture

Ruchi Allen on 18 Nov 2022 10:51:47

RE: subtotals for matrix

i want to add additional rows to the bottom of the Matrix where with total I can show show of the requirements

Power BI User's profile image Profile Picture

Chandra Vadana Rajamohan on 22 Jan 2022 12:26:32

RE: subtotals for matrix

You can easily customize your totals and subtotals using Inforiver, check out this video.

Power BI User's profile image Profile Picture

Divine FOKWA on 06 Jul 2020 00:01:20

RE: subtotals for matrix

Please add this feature and the ability to display subtotals per KPI. I am really in need of this. I have 4 KPIs that I am displaying in my report for category A, B and C. Now the subtotal shows the sum of the values of all KPIs. What I want is for the subtotal to break the values by KPI and not just the total value. Example: A subtotal KPI "student_count" = student_count_cat_A + student_count_cat_B + student_count_cat_C

Power BI User's profile image Profile Picture

Joe Natarajan on 05 Jul 2020 22:56:31

RE: subtotals for matrix

Please add this option. Our users are all Senior executives who want to print in excel and take the pages to meetings. It should be just like printing pivot tables in Excel .

Power BI User's profile image Profile Picture

Mike Ford on 05 Jul 2020 22:55:39

RE: subtotals for matrix

This is a basic option of customizable reports. We are able to toggle grand total, why not subtotals?

Power BI User's profile image Profile Picture

Kasia on 05 Jul 2020 22:53:03

RE: subtotals for matrix

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.

Power BI User's profile image Profile Picture

Aaron Berman on 05 Jul 2020 22:48:13

RE: subtotals for matrix

This is a core Qlikview feature that allows one to select which fields should have subtotals. As reports often can have 5+ fields, but the interface should not subtotal all, this is a critical feature to make the transition from Qlikview to PowerBI

Power BI User's profile image Profile Picture

Pat500 on 05 Jul 2020 22:43:16

RE: subtotals for matrix

Subtotals in the matrix visual clutter otherwise good reports. Need to be able to customize when the totals shows up, If you use a hierarchy, you should get just one subtotal for all items in the hierarchy. Allowing end users to select when to subtotal would work as well.

vote! vote! vote!

Please consolidate this idea.

Power BI User's profile image Profile Picture

Ken Loewen on 05 Jul 2020 22:39:56

RE: subtotals for matrix

The need here is to select which fields will be subtotaled at which levels (e.g., I may not need a subtotal for changes in *every* other field.)