Forum Discussion

Qasim_Jan's avatar
Qasim_Jan
Frequent Visitor
2 years ago
Solved

Keep Original Sort Order Of A Column Table.

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, i...
Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    Hi Qasim_Jan ,

     

    Before you perform your pivot step in Power Query, go to the Add Column tab > Index Column > 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.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
2 years ago

Hi Qasim_Jan ,

 

Before you perform your pivot step in Power Query, go to the Add Column tab > Index Column > 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.

 

Pete

  • Qasim_Jan's avatar
    Qasim_Jan
    Frequent Visitor
    2 years ago

    Hi BA_Pete ,

    Your suggestion to add an index column before the pivot and then sorting by the index column and year was spot on. It worked like a charm!

    Your expertise and willingness to assist are truly appreciated. Thank you once again for your prompt and effective help.

    Best regards,

    Qasim