Forum Discussion
Sorting a table using multiple columns
I see this tread is quite old, but sorting a visual by one column and then a second column is as simple as clicking the 1st column header to sort ascending or decending. Then simply hold the <Shift> key down and click on the header of the second column.
Of course you can just keep the <Shift> pressed and click on a 3rd, 4th etc until happy.
I hope this helps.
Steve B
Yes it is possible, but not from the visual side
You will have to do all the sorting based on multiple columns in the Power Query and then build you visual using the table.
If you have already built a visual, changing the sorting now might not show the proper sorting. In such case you will have to re-create the visual from scratch
Here's how the M code will look once you sort in Power Query
= Table.Sort(#"Changed Type",{{"Team", Order.Ascending}, {"Plan", Order.Descending}})You can see from the below image that inspite of not applying sorting in the visual, due to the sorting at power Query, my data looks sorted as expected
i.e. In the Visual Team is sorted in Ascending Order and then Plan is getting sorted in descending order with in each Team.
You can sort multiple columns in a table just by holding the shif key and clicking the column headers you want to sort.