Matrix table. Order table with most recent month to far right and not January

[MeyertCCU]

This is how it orders month. My most recent date is September so October November and December should be on the left of the table and not right.. Also if I want more than 12 months I want those to add to the left. 
 

NOt sure how but it is working with my line chart. 
How can I get the matrix to look at both my month and year..

My date is like this and it is the same way on the line chart. 

Thank you, 

[Anonymous · Accepted solution]

Hi @MeyertCCU ,

Please try [Year] and [Month] in the column fields of the matrix and expand all the down one level in the hierarchy.

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[MeyertCCU]

Not sure how to Edit. My title says January Far right but I meant December.. If I want 13 months I want it to be October 2022 to far left and September 2023 far right.