Skip to main content

Power BI

Needs Votes

Please provide way to remove Total from Matrix viusalization.

Vote (99) Share
David Hager's profile image

David Hager on 14 Aug 2015 23:15:50

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

GJ 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

WVanpeel 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

Mike 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

Pritesh Ostwal 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

Gameiro 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

Power BI User 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

Dan 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,