Forum Discussion
Sorting matrix visual
Hello All,
I need quick help in this,
I have a tranformed table in this format,
| A | PP | 544 |
| A | SV | 35 |
| A | CS | 65 |
| A | LM | 56 |
| A | NE | 787 |
| A | NS | 87 |
| A | EBI | 98 |
| A | Rev | 78 |
| A | EB | 54 |
| A | FC | 65 |
| A | GC | 89 |
| A | FCC | 888 |
| A | NT | 21 |
| A | GW | 4 |
| A | GWC | 23 |
| A | PW | 88 |
| A | HJ | 98 |
| B | PP | 23 |
| B | SV | 45 |
| B | CS | 45 |
| B | LM | 78 |
| B | NE | 35 |
| B | NS | 42 |
| B | EBI | 54 |
| B | Rev | 46 |
| B | EB | 56 |
| B | FC | 5 |
| B | GC | 545 |
| B | FCC | 21 |
| B | NT | 4 |
| B | GW | 23 |
| B | GWC | 88 |
| B | PW | 98 |
| B | KK | 23 |
| C | PP | 45 |
| C | SV | 45 |
| C | CS | 56 |
And I want a matrix with output like this and in this order only, no matter how raw data's order gets changed
| A | PP | 544 |
| SV | 35 | |
| CS | 65 | |
| LM | 56 | |
| NE | 787 | |
| NS | 87 | |
| EBI | 98 | |
| Rev | 78 | |
| EB | 54 | |
| FC | 65 | |
| GC | 89 | |
| FCC | 888 | |
| NT | 21 | |
| GW | 4 | |
| GWC | 23 | |
| PW | 88 | |
| HJ | 98 | |
| B | CS | 45 |
| EB | 56 | |
| EBI | 54 | |
| FC | 5 | |
| FCC | 21 | |
| GC | 545 | |
| GW | 23 | |
| GWC | 88 | |
| KK | 23 | |
| LM | 78 | |
| NE | 35 | |
| NS | 42 | |
| NT | 4 | |
| PP | 23 | |
| PW | 98 | |
| Rev | 46 | |
| SV | 45 | |
| C | CS | 56 |
| PP | 45 | |
| SV | 45 |
Hi Jessica_17,
Thank you for posting your query in the Microsoft Fabric Community Forum.
You can keep your custom sorting without showing the SortOrder column. Just add SortOrder to the matrix rows once, sort the matrix by it, and then remove SortOrder from the rows. The sorting will stay applied, but the SortOrder values will no longer appear anywhere including rows, tooltips, so the client won’t see them.
Best regards,
Ganesh Singamshetty.
11 Replies
Jessica_17 , Make sure you create sort columns (preferably in Power Query) on the first two columns or and then sort the matrix of rows.
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
https://youtu.be/cyWVzAQF9YU?t=39560HI amitchandak ,
This is not working on my case, even if I sort the merged column on basis of ranking column, the other columns are not showing sorted at all, it still shows alphabetically sorted
Jessica_17 , Consider Sub Category Index or Sub Category Rank in power query and then use that new column sort column for second column
Learn in Power Query - Subcategory Index and Rank: https://youtu.be/cyWVzAQF9YU?t=68148
Hi Jessica
Have you choosen Matrix and added the columns like this?
Yes, I have added values and columns like these
Hii Jessica_17
Power BI cannot sort the same Code in different ways for A/B/C.
Create a Sort table with a custom SortOrder per Cluster, relate it using Cluster+Code, add SortOrder to the visual, and sort by that column. This gives a stable, fixed sequence exactly as required.
Hello Jessica_17,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hello Jessica_17,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
