Skip to main content

    Power BI

    New

    matrix: Hide column and sort by each column

    Vote (23) Share
    Min Zhang's profile image

    Min Zhang on 29 Oct 2018 12:13:12

    Can hide the column in the Matrix and sort the data by each column

    Comments (3)
    Min Zhang's profile image Profile Picture

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

    RE: matrix: Hide column and sort by each column

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

    Min Zhang's profile image Profile Picture

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

    RE: matrix: Hide column and sort by each column

    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.

    Min Zhang's profile image Profile Picture

    1a85f62f ca57-42f0-8e22-f0e1261186ce on 05 Jul 2020 23:43:28

    RE: matrix: Hide column and sort by each column

    I agree. Need the ability to have the column in the Matrix for sort purposes but need the ability to hide it from display.