Want to sort matrix by subrows

[ymar]

Hi,

In my matrix, each product has Name and description and associate to one subcategory which is associate to one category. I expand all the rows column and now I have 4 columns: Name, Description, Category and Subcategory. When I click on sort button on Name in the header, the sort functionality work but when I click on sort button on Description, Category and Subcategory in header, the sort functionality do not work.
How can I handle this issue?

[v-fenling-msft · Accepted solution]

Hi,@lbendlin 

thanks for your concern about this issue.

Your answer is excellent!

Hi,@ymar 

I am glad to help you. 

According to your description, you want to sort matrix by subrows? 

If I understand you correctly, then you can refer to my solution. 

Since you didn't provide a dataset for testing, I assumed some of the data myself. 

Remember to add relationships to them: 

Then you need to follow the steps in the picture to set up your sort: 

Here's the sorted result: 

You can also sort by other fields with this method. 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Consider using the "sort a column by another column"  feature.

[ymar]

I'm new in power Bi. Can you give me some tips on how to use this feature?

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...