Solved: Matrix Order doesn't match Powerquery column

Anonymous · ‎08-01-2019

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 · ‎08-01-2019

@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.

Anonymous · ‎08-01-2019

@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.

Matrix Order doesn't match Powerquery column