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. I am seeing the matrix sorted by Measure only. The first column is also sorted by measure so the order is B, A, C, not B, C, A as required. I think what your measure is doing is trying to calculate a value based on the Number and the MonthNo so we can sort only by that one value. Is there no way to sort subcategories? I have at least a thousand categories that I am going to be filtering but the "months" remains consistent. Can't I just somehow sort by MonthNo? Is there a better way to present the data than a matrix? Thank you again.

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

Hi Captenaj 

Not fully understand it.How about sorting rows in query editor like below?

Regards,

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

    Hi Captenaj 

    Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

    Regards,