Forum Discussion
Change default sort by Total in Matrix
Hello,
I have the following matrix and I sorted it by the value MAT TY, but it is sorted default by the Total Column. How can I sort it by the 'Store 2' column for example? I already have the Stores in the order that I want, but I also want to sort by the value in a specific column.
Thank you!
6 Replies
- Stemar_Aubert
Resolver I
Hi Anonymous
When you hover above the chart, you would see this appearing somewhere on a corner.
Click on this, then you can select a sorting column and order as well.
Hi Stemar_Aubert ,
Thank you for your reply. I sorted by the Value, but I can't choose the Column that I want (Store 2).
- amitchandak
Super User
Seem like no direct option. When there is no column you can sort by clicking. But when you have a column in matrix click do not allow to sort and even if sort by sort option, it is on grand total.
- Stemar_Aubert
Anonymous
Ranking is, IMO one of the most tricky aspect regarding DAX.
Most of the time I get "1" for RANKX results, it's because my relationships aren't correct. Perhaps that's why it doesn't work for you.
Also, consider perhaps another visual, such as a regular table instead of your matrix, to sort the columns.
