How to sort months and years in a descending order in a matrix visual using date hierarchy

[pulpfiction]

Hello everyone, 

I am trying to sort years and months in a descending order. I have a Date table and I am using the the Date hierarchy from it - only Year and Month.

I have tried to sort the Date column by adding an index column in a descending order and sorting the Date column by it. It didn't work. I am looking for a solution that doesn't use calculated columns as I am allowed to have those in Power Query only. 

This is what I currently have: 

This is what I would like to show in PowerBI:

Thank you! 

[amitchandak · Accepted solution]

@pulpfiction , You can create a date table and have Month and Year in that and use that visual

Month = month([Date])

Year= Year([Date])

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.