Forum Discussion

Omesh's avatar
Omesh
Helper 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
Community Champion
2 years ago

Hi,

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

Data:


End result:

 

 

Omesh's avatar
Omesh
Helper I
2 years ago

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

  • ValtteriN's avatar
    ValtteriN
    Community 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
      Helper 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