Forum Discussion
How to sort Matrix Visualizations
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 |
4 Replies
Hi,
Can you describe the issue a bit more? The default sorting seems to solve this:
Data:
End result:The text field comes from a table, and the rank is a measure based on a numeric value from table
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/
