Sort Matrix Columns Descending Order

Thanks speedramps 

I tried the reverse item, didn't change the order on the visual. Tried Asc and Desc.


I tried to remove all columns and added index column from Date Table - Matrix columns are Asc

I went to Data View and sorted the Index Column Desc.
I went back to Report View. Matrix Columns are still in Asc order

What am I doing wrong?

Thanks,
-w

Sorry I meant to press save but hit accept solution by total accident whilst inputting this post, how rude 😮😮

but this solution should work....

Click here to download example 

I assume your 1,2,3,4,5 to 12 column headings are months

In the query editor add a column called revmonthsrt = [month] * -1

to create -1,-2,-3,-4,-5 to -12

then in modeller sort month by revmonthsrt 

check datatypes ar numbers

your report will then dislay column headings decsending 12,11,10,9,8 etc

Please click thumbs up and accept as solution buttons. Thanks