Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Matrix Mutli tier sorting

Hi   trying to find a way to do multi level sorting in a Matrix I came up empty. it is true that this feature is not supported !!!!   are there any workarounds?   BR   Chronis
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Current power bi not support apply multiple sorting orders on matrix, you can refer to following link to create a custom sort order table to apply multiple column sorting:

    Custom Sorting in Power BI

    Sorting by multiple columns

    Custom Order=
    COUNTROWS (
        FILTER (
            Table,
            ISONORAFTER (
                    [Column1], Table[Column1], DESC,
                    [Column2], Table[Column2], DESC,
                    [Column3],Table[Column3], ASC
            )
        )
    )

    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

Current power bi not support apply multiple sorting orders on matrix, you can refer to following link to create a custom sort order table to apply multiple column sorting:

Custom Sorting in Power BI

Sorting by multiple columns

Custom Order=
    COUNTROWS (
        FILTER (
            Table,
            ISONORAFTER (
                    [Column1], Table[Column1], DESC,
                    [Column2], Table[Column2], DESC,
                    [Column3],Table[Column3], ASC
            )
        )
    )

Regards,
Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous  thank you....

     

    I'm quite surprised that powerBI would not support such a basic feature...