Keep Original Sort Order Of A Column Table.

Question

Hello Power BI community,I am currently facing an issue while trying to create a pivot table in Power Query with unpivoted data. Specifically, I have three columns: EmployeeName, Year, and Count, in unpivoted order. My goal is to pivot this data while preserving the original sort order of the EmployeeName column and arranging the years in ascending order.However, when I pivot the data by selecting the Year column, the EmployeeName order changes. I would greatly appreciate your assistance in achieving this objective while maintaining the initial sort order of the EmployeeName column and ensuring that the years are displayed in ascending order.Your expertise and guidance on this matter would be invaluable to me. Thank you in advance for your time and assistance.Best regards,Qasim

ba_pete · Accepted Answer

Hi&nbsp;Qasim_Jan&nbsp;,
&nbsp;
Before you perform your pivot step in Power Query, go to the Add Column tab &gt; Index Column &gt; From 1. This will index your table in the current sort order.
After you pivot , you can then sort by the index column and year to get the data in the exact order you want.
&nbsp;
Pete

Forum Discussion

Keep Original Sort Order Of A Column Table.

2 Replies

Related content

Filtering a nested table by original column

Original table name

Direct Lake Model - Calculated Column/Tables

Create table with distinct values from column of original table

Change the wording "use original column name as prefix"