Sorting matrix visual

[Jessica_17]

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

[v-ssriganesh]

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.

[v-ssriganesh]

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.

[ThomasWeppler]

Hi Jessica

Have you choosen Matrix and added the columns like this?

[Jessica_17]

HI @ThomasWeppler 

Yes, I have added values and columns like these

[rohit1991]

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.

[Jessica_17]

HI @rohit1991 ,

Is there any other workaround for this?
As while hovering over values, we are able to see sorting ranks which clients do not want

[v-ssriganesh · Accepted solution]

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.

[amitchandak]

@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=39560

[Jessica_17]

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

[amitchandak]

@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

[Jessica_17]

HI @amitchandak 
As I mentioned, the data can change in raw format itself, so indexing and ranking might not work all the time.