How to sort Month under Year hierarchy

[JustinDoh1]

I am attaching my Pbix file here.

I am trying to order month in descending order (in a slicer).

Example:

Feb --> Jan for 2022

Dec --> Nov --> Oct ... --> Jan for 2021.

This is what I have now:

Year is fine (as I selected this).

I spent a lot times trying to create a date hierarchy, and by watching one YouTube, I was able to create Hierarchy at Model mode like this:

I am not sure whether this is the best approach because I thought I could just create a date hierarchy if the data type is DATE, but it seems to be little tricky.

Now, one issue that I am having is, when I try Sort by column (using "Date"), I am getting "Circular Dependency" error (so something is messed up).

I think creating a separate Calendar table and using that would be an ideal, but now, output (Amount) comes from Data table, so I am not sure how to make it work.

 Thank you.

[JustinDoh1]

@amitchandak 

Thank you Amit for your help.

This is little bit complex than I thought.

I will learn one tip at a time. 

[amitchandak · Accepted solution]

@JustinDoh1 , Create two columns in your table

Month1 = FORMAT([Date],"mmm")
Month1 sort = month([DAte])

Month Rank = RANKX(ALL('Date'),'Date'[Month Year Sort],,DESC,Dense)

Sort month1 on month Rank and use that in visual

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c