topic Re: How to sort Matrix Visualizations in DAX Commands and Tips

How to sort Matrix Visualizations

Omesh — Mon, 22 Apr 2024 04:44:46 GMT

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

Re: How to sort Matrix Visualizations

ValtteriN — Mon, 22 Apr 2024 05:52:29 GMT

Hi,

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

Data:

End result:

Re: How to sort Matrix Visualizations

Omesh — Tue, 23 Apr 2024 04:13:39 GMT

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

Re: How to sort Matrix Visualizations

ValtteriN — Tue, 23 Apr 2024 05:59:03 GMT

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/

Re: How to sort Matrix Visualizations

Omesh — Wed, 24 Apr 2024 05:15:04 GMT

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