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