Remove automatic column's sort in a matrix

[Anonymous]

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 ! 

[vojtechsima · Accepted solution]

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]

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

So it's perfect, thank you ! 

[vojtechsima]

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