Sort years chronologically

[AlphaTau]

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.

[grantsamborn · Accepted solution]

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.