Forum Discussion
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
7 Replies
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!
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
If you click on the visual 3 dots should appear (normally top right). It should give you options on sorting.
- aj1973
Hi ShrimpSurf
In the table where field date/year is, add a column where you rank the years descending, like 2022 equals 1, 2021 equals 2 , 2020 equals 3.... Once the column is added go back to the field in the report and sort it by
the name of the new added column.
To avoid creating a static table to sort years I would create a new column being 2100 - [Year] and simply sort on that new integer value
