Forum Discussion
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 🙂 ...
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.
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.
It's not very clean but it's working correctly.
So it's perfect, thank you !
Anonymous
I definitely agree that it's not the cleanest, but as you said, it does the job 😄