Forum Discussion
Solved
Sorting a table using multiple columns
Hi All, Is it possible to sort a table using multiple columns? My table looks like this and i would like to sort by "Year" first and then by "Month". Is it possible?
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
Hello,
I found this thread and am doing somethign similar. I am using this method with the M code, and it works perfectly. I am tryign to now get the table to display as the data in the query does, but cannot figure out why it is sorting columns alphabeticlly and not following the source sorting?
New to Power Bi, so would need simple or easy to follow help.
Thank you,