Skip to main content

    Power BI

    Needs Votes

    Turn off Matrix Total

    Vote (161) Share
    Matt Allington's profile image

    Matt Allington on 02 May 2020 02:36:48

    It is not intuitive how to turn off the Grand Total row in a matrix. If you go to Format\Grand Total, there is no option to turn it off. Instead you have to go to Subtotal\Per Row Level and then turn Header off. This is not intuitive and not discover able unless someone else shows you how to do it.

    I have a demo of how it works now here https://twitter.com/ExceleratorBI/status/1256308974313332737

    Please simply put a slider under Grand Total to show/hide the grand total in a matrix (and table visual)

    Comments (2)
    Matt Allington's profile image Profile Picture

    aa4bf481 5afe-4c21-8f23-003354d570e3 on 06 Jul 2020 00:13:00

    RE: Turn off Matrix Total

    This would be a welcome feature.

    Matt Allington's profile image Profile Picture

    65ee3398 627d-4af9-8f7f-d9a522e7f24d on 06 Jul 2020 00:12:58

    RE: Turn off Matrix Total

    Hi Matt,
    thx for your reply to get rid of the grand total. I agree with you to have a slider for to show/hide the grand total in the grand total bucket.

    FrankAT