Forum Discussion
Sort years chronologically
I'm working on a dataset that has a country and a year columns. After doing the transformations in Power Query and loading to Power BI the sorting of the dataset in Data view is messed up. I would like to sort the data by country and then by year.
But for some reasons I cannot sort by two columns.
Is there anything I can do?
Is sorting the table in Dataview affects the visuals? Because when I make the line chart the years are not in chronological order
Please help.
Hi AlphaTau
In PowerQuery, you can sort by multiple columns and create an index based on that sort.
Try this in PowerQuery:
1. Select the Country column and sort accordingly
2. Right-click the next column (Year) and sort accordingly.
At the far right of the column headers next to the down arrow to select/sort, you should see a tiny "1" or "2" next to Country and Year respectively.
3. Add a new Index column.
4. After you are done in PowerQuery, the Index should be available to sort by.
I hope this helps.
1 Reply
Hi AlphaTau
In PowerQuery, you can sort by multiple columns and create an index based on that sort.
Try this in PowerQuery:
1. Select the Country column and sort accordingly
2. Right-click the next column (Year) and sort accordingly.
At the far right of the column headers next to the down arrow to select/sort, you should see a tiny "1" or "2" next to Country and Year respectively.
3. Add a new Index column.
4. After you are done in PowerQuery, the Index should be available to sort by.
I hope this helps.