Forum Discussion
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 ...
Hi FuzzyYabs
You may try to add an index column as requested. Then use Sort by Column as below picture.
Regards,
Cherie
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?
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