Forum Discussion

Captenaj's avatar
Captenaj
Frequent Visitor
7 years ago

Sorting a matrix second level - sort by column not working

In a matrix I am trying to sort the top level the hierarchy by most common but the second level by another factor. For instance, the top level may be items sold sorted by number of items, and the sec...
Need Help
Captenaj's avatar
Captenaj
Frequent Visitor
7 years ago

Thank you for your reply. In the matrix I want to sort the first column by numbers (most common at the top). In your example the order would be B, C, A. The next column I want to sort by month order: Jan, Feb, March. In your data the first column is sorted alphabetically and the second by month. Just as you said "If you just want to sort the second level.You may create a month table and use 'sort by column' for it." That's exactly what I want to do, I just want to sort the second level and I want to leave the top level alone. How can I do this?

 

Thank you for your help.

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Captenaj 

Please check the attached file Sorting a matrix second level_2.pbix in above reply.It shows you how to get the sort only for the second level.

Regards,

  • Captenaj's avatar
    Captenaj
    Frequent Visitor
    7 years ago

    Thank you for the reply. So are you saying there is no way to sort the first column by one parameter and the second column by a different parameter?