Forum Discussion

aburling1989's avatar
aburling1989
Frequent Visitor
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 aburling1989 ,

     

    You could create a rank column to sort category.

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

     

     

aburling1989's avatar
aburling1989
Frequent Visitor
6 years ago

Hi az38 ,

 

Many thanks for the quick response. The problem is the values in the 'Category' column are not unique, so even if I concatenate the 'Group' and 'Sort' columns I still get this error message: "There can't be more than one value in 'Category' for the same value in 'Surrogate Order Column'.

 

If I concatenate the 'Group' and 'Category' column it would work as they become unique values but I want to avoid doing that if possible.

 

Many thanks,

Ashley

 

 

 

az38's avatar
az38
Community Champion
6 years ago

aburling1989 

Do you create measure or column?

If column, there shouldn't be such error

  • aburling1989's avatar
    aburling1989
    Frequent Visitor
    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