Re-ordering x-asis to show most recent month

[amend]

I'm still learning Power BI, and I have a sheet with dates from 2021 and 2022, but I can't get the x-asis order (like the last column should be June-2022, and the first July-2021, if I have date from the last 12 months). How I can re-order them?

[v-yalanwu-msft · Accepted solution]

Hi, @amend ;

You could put date to x-axis, then drill down it.

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[johncolley]

Hi @amend ,

If you are using a calendar table - add a Month Year column

Month Year = FORMAT('Calendar'[Date], "MMMM YYYY")

Then make sure you format it as per the following image:

Then use this Month Year column as your Axis. 

If you're not using a Calendar Table - see this link to set one up: https://hevodata.com/learn/power-bi-calendar-table/ 

If this solves your problem, please mark it as a solution!