Forum Discussion

Omesh's avatar
Omesh
Icon for Helper I rankHelper I
2 years ago

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...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
Omesh
Icon for Helper I rankHelper I
2 years ago

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