Skip to main content

    Power BI

    New

    Hide columns in a table Matrix to apply sorting by several levels

    Vote (9) Share
    's profile image

    on 15 Jun 2018 05:01:28

    Hide columns in a table Matrix to apply sorting by several levels

    Comments (2)
    's profile image Profile Picture

    1fac0baf 9610-4152-8bad-924d339565a1 on 06 Jul 2020 00:09:53

    RE: Hide columns in a table Matrix to apply sorting by several levels

    Beef up the Matrix hierarchical sorting functionality as per:
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11185431-add-a-multiple-columns-sort-featue 

    's profile image Profile Picture

    d8167c53 49b6-4b72-8758-46acab9978e6 on 05 Jul 2020 23:46:29

    RE: Hide columns in a table Matrix to apply sorting by several levels

    In showing GL info in Matrix, need to group by Department and Account. But need to order Accounts by hidden sort as they shouldn't be sorted by Acct # nor Acct Name - need a hidden sort order as secondary to Department. Don't want to show or have totals by that hidden sort order.