Forum Discussion
Want to sort matrix by subrows
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?
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.
4 Replies
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.Consider using the "sort a column by another column" feature.
I'm new in power Bi. Can you give me some tips on how to use this feature?
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-Forum/ba-p/963216
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/1447523
