Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove automatic column's sort in a matrix

Hello everyone, 

 

I have a issue. 

 

I would like use a matrix with a column of numbers, but with the order of number which is in the column.

Pictures will help you to understand 🙂

 

 

I would like to have the same order than the original column in the matrix. 

 

Do you know if it's possible ? 

 

Thank you in advance ! 

Need Help
Tips and Tricks
  • vojtechsima's avatar
    vojtechsima
    4 years ago

    Hi, Anonymous ,
    I couldn'T find any proper solution, but there's a workaround, if you want your values sorted as they are placed in Data Model, create an Automatic Index column in Power Query and then sort your table based on this Index.

    Then you get your desired output.

3 Replies

  • vojtechsima's avatar
    vojtechsima
    Super User
    4 years ago

    Hi, Anonymous ,
    I couldn'T find any proper solution, but there's a workaround, if you want your values sorted as they are placed in Data Model, create an Automatic Index column in Power Query and then sort your table based on this Index.

    Then you get your desired output.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It's not very clean but it's working correctly. 

       

      So it's perfect, thank you ! 

      • vojtechsima's avatar
        vojtechsima
        Super User
        4 years ago

        Anonymous 
        I definitely agree that it's not the cleanest, but as you said, it does the job 😄