Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

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

    Gary Thomann 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

    Gordon Hayward 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.