Forum Discussion
Sorting matrix visual
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.
HI 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 amitchandak
As I mentioned, the data can change in raw format itself, so indexing and ranking might not work all the time.