Forum Discussion
Helper IIHow to Reverse Sort of Column Headers
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
ShrimpSurf bcdobbs I don't believe Power BI will let you sort the column headers in descending order if there are also row fields added to the matrix. I think a technique like the one described below is required for this:
https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/
- bcdobbs
Community Champion
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.
Haha bcdobbs definitely seems like one of those things that should be possible, but still has to be "hacked" ☹️.
Thanks, you too!
