Skip to main content

    Power BI

    Needs Votes

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

    Vote (223) 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

    0eff933e 5488-4c9d-a928-b8ead5f5e1de 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

    07ebefeb fae9-4d0f-96a0-b196ebaf086a 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

    441a8bf1 229c-46b7-813c-5b05aef03981 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

    7a32d909 502a-4837-8dcc-bfc5c10473d3 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.