Forum Discussion

ShrimpSurf's avatar
ShrimpSurf
Icon for Helper II rankHelper II
4 years ago
Solved

How 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!  
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Thanks Anonymous, that'll teach me to reply from memory! Had to boot laptop up to check but yes 100% correct you do have to trick it with a sort order column.

 

Have a great new year.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Haha bcdobbs  definitely seems like one of those things that should be possible, but still has to be "hacked" ☹️.

 

Thanks, you too!