How to change order of dates within a visual?

[DRJ1994]

Hi all,

Hope you don't mind this post and hopefully someone can help me with some trouble I have been having. I have a graph that shows the last 12 months and shows it as January to December and is not taking the year into account.

Please see screenshot of visual below.

The January - April relates to 2022, and May onwards relates to 2021. Is there anyway I can have it so it runs as May 2021 to April 2022?

Thanks in advance!

[ddpl]

Hi,

You should change the format of Date column as per below:

 & then 

[DRJ1994]

Thank you for taking the time to respond and demonstrate, that's really helpful and can see that would've worked too. I have already adopted Pat's approach below and that worked for me too. Thanks again. 

[mahoneypat · Accepted solution]

You need to add a Sort By column to get your desired order.

Sort one column by another column in Power BI - Power BI | Microsoft Docs

FYI that there a date tables out there you could use that already have a YearMonth column you could use too. Here is an example.

No Sort Date Tables! – Hoosier BI

Pat

[DRJ1994]

Thanks Pat, this helped and achieved exactly what I wanted it too!