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

  • 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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      Anonymous  thank you....

       

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