How to sort Matrix Visualizations

[Omesh]

I want to sort a matrix visualization in Power BI with three columns: two text and one numeric columns. I need to sort it based on the Rank column while keeping the State column in its original order. Essentially, I need to sort based on two columns: State (text) and Rank (numeric).
Data:

State	City	Rank
Maharashtra	Nagpur	4
	Thane	3
	Mumbai	1
	Pune	2
MP	Indore	2
	Ujjain	4
	Bhopal	1
	Jabalpur	3

Output:

State	City	Rank
Maharashtra	Mumbai	1
	Pune	2
	Thane	3
	Nagpur	4
MP	Bhopal	1
	Indore	2
	Jabalpur	3
	Ujjain	4

[ValtteriN]

Hi,

Can you describe the issue a bit more? The default sorting seems to solve this:

Data:

End result:

[Omesh]

The text field comes from a table, and the rank is a measure based on a numeric value from table

[ValtteriN]

Hi,

by clicking on the yellow area in matrix the matrix is sorted. Here the column2 is a text field from table and measure 25 is numeric measure. 

You can add column sortung in the data:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Omesh]

Thanks for answering but it not resolve my question, as seen you are just sorting only on measure because in your POC table data is already sorted. try to take more data in unsorted order and applying custom sort on state & measure