Forum Discussion

FuzzyYabs's avatar
FuzzyYabs
Frequent Visitor
8 years ago
Solved

Two level sorting - Matrix

Hello Datanauts!    Been looking into the thread for a solution but couldn't find one.  I need to sort the column of a certain matrix (Category 2). But the problem is it only sorts alphabetically ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
8 years ago

Hi FuzzyYabs

 

You may try to add an index column as requested. Then use Sort by Column as below picture.

 

 

Regards,

Cherie

 

 

 

FuzzyYabs's avatar
FuzzyYabs
Frequent Visitor
8 years ago

Hello Anonymous,

 

Did this. However, that would mean I would be showing the index as first column's values. The idea is that I should be able to sort the matrix using the index but still showing the "Category2".

 

By the way, on your example, the index was a data. The index I created is a measure. Do you think this affects that? 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    8 years ago

    Hi FuzzyYabs

     

    Yes, It's better to use index column instead of measure if you want to use 'sort by column'. You may add index column in Query Editor or create it with Dax. 

     

    Regards,

    Cherie