Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sort column by multiple columns

Hi,   I was wondering if it was possible to sort a column based on two columns?   In the example below I'm trying to sort the Category by the Sort_Order column. The problem is that the sort order...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    You could create a rank column to sort category.

    Rank =
RANKX ( 'Table', 'Table'[Group] * 10 + 'Table'[Sort_Order],, ASC, DENSE )

     

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

Do you create measure or column?

If column, there shouldn't be such error

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38 ,

 

I added it as a column and it certainly sorts the data correctly; However the issue I still have is that I can't specifically sort the 'Category' by this column. So if I was to add 'Category' to a slicer it still defaults the sort order alphabetically, but I would want it sorted by the new 'Surrogate Order Column'.

 

Thanks again for your help.

Ashley