Forum Discussion
ShrimpSurf
Helper II
Helper IIHow to Reverse Sort of Column Headers
How do you reverse the sort of column headers? In my example the sort is from 2018 to 2022. I would to go from most recent year to oldest. Help please!
Hi ShrimpSurf
You can create a conditional column to add a reverse index .
(1)Add a conditional column in Power Query .Set year 2022=1,2021=2…
(2)Go back to Desktop view, and choose the column [year] ,sort by the conditional column .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regard
Community Support Team _ Ailsa Tao
bcdobbs
Community Champion
Community ChampionIf you click on the visual 3 dots should appear (normally top right). It should give you options on sorting.