Skip to main content

    Power BI

    Needs Votes

    Please provide a way to enable/disable Subtotals for columns for matrix visualization

    Vote (281) Share
    Alexandre Durocher's profile image

    Alexandre Durocher on 29 Mar 2016 02:42:48

    As in Excel, it would be nice to be able to add or remove subtotals by column for Matrix Visualization instead of having either totals for all columns or none.

    Comments (34)
    Alexandre Durocher's profile image Profile Picture

    Eric on 05 Jul 2020 22:35:16

    RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

    The matrix is unusable with more that one field without the ability to choose which level of the matrix you want the subtotal to display on. AKA it looks like crap with multiples of the same subtotal.

    Alexandre Durocher's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:25:15

    RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

    Agreed! I would love to be able to have the same subtotal functionality that I'd have in a pivot table in this visualization. So often I want first and second level subtotals, but not at the lowest level, as it is often redundant and makes the visualization look busy. +3!!

    Alexandre Durocher's profile image Profile Picture

    Thomas ivarsson on 05 Jul 2020 22:22:01

    RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

    Yes. If you do not have categories/levels on rows in a matrix it looks awful. I need the matrix for the date dimension with single level row columns.

    Alexandre Durocher's profile image Profile Picture

    Razi on 05 Jul 2020 22:20:58

    RE: Please provide a way to enable/disable Subtotals for columns for matrix visualization

    Agreed. Many times, those simply get in the way.