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

3fb505cf 59b0-44d3-8477-f181237c95a7 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

6d3885e3 a211-4adb-a328-e1ef2a2a1c99 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

66795607 b938-421c-81c5-9f28f3ebc017 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

f802c216 df26-404c-bc7f-6223dd004b8b 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

99943dde d96f-e811-a960-000d3a1be7ad 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

1f6d1072 0191-459d-8e1f-a98427db0564 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

fc43dc43 73ce-e911-a96a-000d3a4f36ce 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

7701a155 7ea8-4fef-90c4-f08ff425b955 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

46c5a1ff 0f69-4d0f-931d-a9e3bdbdd4fb 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

97c441bf 4e3b-4d66-82dc-16b0ec4123ee 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