Skip to main content
Microsoft Idea

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

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

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

Hack solution - just make all the font the same color as the background. Not the most elegant solution but looks way better than all the subtotals.

David Hager's profile image Profile Picture

Mike on 05 Jul 2020 22:45:21

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

Agreed, the Excel functionality for the subtotal customization should be implemented, right now the Matrix is not usable with several lines of non-descriptive subtotals. I am really surprised that Power BI is a Microsoft product yet they took several steps back from the functionality already implemented in other products they provide.

David Hager's profile image Profile Picture

Jonathan Poulin on 05 Jul 2020 22:41:17

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

I would like to have the ability to remove total for specific columns. Right now, the totals are shown for all columns (when property 'General -> Total row' is set to 'On').

David Hager's profile image Profile Picture

Power BI User on 05 Jul 2020 22:38:11

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

I like to use the Matrix because of the formatting. I do not want to subtotal on every column. The report is messy with multiple total lines with same number.

David Hager's profile image Profile Picture

Edwin Bensoussan on 05 Jul 2020 22:37:00

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

Yes, It will signifiantly improve the User Experience. (Total and SubTotals)
thank you

David Hager's profile image Profile Picture

Power BI User on 05 Jul 2020 22:36:50

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

Agreed - very annoying not being able to control what you want to total and what you don't want to total - looks horrible with 3-4 columns all trying to total. End up with 4 total lines in a row with the same number

David Hager's profile image Profile Picture

Jose Peguero on 05 Jul 2020 22:36:10

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

this is very useful, please add it.

David Hager's profile image Profile Picture

Art Allmon on 05 Jul 2020 22:35:06

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

Please add the ability to turn off sub-totals at different levels of the Matrix reporting. My users ask for multiple columns in a matrix but they do not want a sub-total for each column. For example they want Customer Number and Customer Name but they only need one total for the customer. Or they want Part Number and Part Description but they only want one total for the part.

David Hager's profile image Profile Picture

s.schoeneberger on 05 Jul 2020 22:35:02

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

and important to delete subtotals

David Hager's profile image Profile Picture

Benny on 05 Jul 2020 22:34:27

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

Very important feature this is, please provide a way out