Skip to main content

Power BI

New

Please provide way to remove Total from Matrix viusalization.

Vote (98) Share
David Hager's profile image

David Hager on 14 Aug 2015 23:15:50

Comments (17)
David Hager's profile image Profile Picture

8898537e 531d-421a-98ca-c602abb9febd on 05 Jul 2020 22:33:27

RE: Please provide way to remove Total from Matrix viusalization.

Yes, this is required future

David Hager's profile image Profile Picture

dcf7aba7 9a85-4345-af9f-ab875916c9cc on 05 Jul 2020 22:30:21

RE: Please provide way to remove Total from Matrix viusalization.

The totals/subtotals in Matrix need urgently to be improved. I showed PowerBI to our business but everyone was suprised by lack of better subtotaling. Need to be able to control subtotals on individual columns (on/off).

David Hager's profile image Profile Picture

b1a92dec c272-447d-be93-5e4edf07a60e on 05 Jul 2020 22:28:49

RE: Please provide way to remove Total from Matrix viusalization.

There are other registered ideas that are almost the same as this one. This uncontrolled idea submitting option is not efficient. I think this is a really important feature but because of the inefficient registration does not get the votes it deserves (now its fragmented).

PBI should mimic Excel pivot table functionality as close as possible.

David Hager's profile image Profile Picture

618f2711 5819-e611-80e2-c4346bad91c4 on 05 Jul 2020 22:18:04

RE: Please provide way to remove Total from Matrix viusalization.

We need this feature as business wants to see SSRS reports in Power BI Grids now and many things can not be displayed the same way.

David Hager's profile image Profile Picture

898842f6 b8e3-4146-9aef-5b050cdb4298 on 05 Jul 2020 22:16:17

RE: Please provide way to remove Total from Matrix viusalization.

Yes, this is usefull

David Hager's profile image Profile Picture

e4afea31 55c3-4304-9aac-c3151a75ac54 on 05 Jul 2020 22:12:49

RE: Please provide way to remove Total from Matrix viusalization.

In addition to adding an option to remove a Total; the totals should be descriptive. It should at least tell you what the totals represent based on the Row used in the report. Region Total, Market Total, Grand Total. or if there is a Sub Total, Total, Grand Total to indicate the different levels.

David Hager's profile image Profile Picture

29918ebf 093d-4303-bec4-000a150e0c7d on 05 Jul 2020 22:11:55

RE: Please provide way to remove Total from Matrix viusalization.

Agreed - if you show the standard presentation (ex. 2014 column, 2015 column and variance column, this Total column sums 2014 and 2015 together. It is very counterintuitive and not useful at all for presentation purposes. There needs to be an option to remove the Total columns.

Thanks,