Forum Discussion
Matrix Order doesn't match Powerquery column
How do I reorder the matrix column:"value.Month" to match column order in Powerquery column:"Value.Month"?
I have attached screenshots for verification - please help!
Powerquery Order- CorrectMatrix Column Order - Wrong
Anonymous - In Power Query, you can add an Index column, which will add a "row number" according to the sorting in place when the index is added.
Then, you can add the index column to your visual and sort by it.
You can also assign a sort by column to another column, but in that case, there needs to be a 1-1 mapping.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
1 Reply
Anonymous - In Power Query, you can add an Index column, which will add a "row number" according to the sorting in place when the index is added.
Then, you can add the index column to your visual and sort by it.
You can also assign a sort by column to another column, but in that case, there needs to be a 1-1 mapping.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.