Forum Discussion

yellowold5's avatar
yellowold5
Helper I
2 years ago
Solved

Sort columns base on two columns

Hi everyone, I wanna create a custom sort columns for my matrix visuals base on two columns, values and order: Value order 1 3 2 2 3 1 4 3 5 2 6 2 7 3 8 0 9 ...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi yellowold5 -  Sorting a matrix visual based on multiple columns directly within the matrix itself is not supported. However, you can achieve a similar effect by creating a custom column in your data model that combines the two sorting criteria as a workaround.

    eg: create a new column with concatenates the Value and Order columns with a "-" separator 

    add this column in your matrix visual and use sort from more options

    Once you have sorted the matrix visual using the new column, you may want to hide or remove this column from the field list to avoid confusion for report. (hide the column from report view).

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi yellowold5 
You can do this in power query editor.

first column by Asc
order column by desc

 

Add index column

 

 

save and apply

 

select your value > sort by column

 

 

This will sort you data according to your ASc+desc combination

 

 

Note : your complete table will sort according to these 2 values not only your Matrix.

 

I hope I answered your question!