Forum Discussion
Sorting by Column in Matrix Visual
It seems you can not order by a date hierarchy! You would have to create a new column that extracts the year from the date hierarchy and sort by this column in descending order!
You may need to add a "Year Offset" column in your data that will show how far off the current date your year is. For example the previous year is -1, current year is 0, and next year is 1. I use this date table in most of my reports and it has this column:
https://radacad.com/all-in-one-script-to-create-calendar-table-or-date-dimension-using-dax-in-power-bi
As for the actual solution... I just created a new column and multiplied the aforementioned column by negative one to flip the order
Then you can sort the year column by this new calculated column.
And your years should be in reverse order!