last year's months mixed with this year's months in monthly sales chart

[Thiago_Melo]

Hi!

I've been having a problem with an analysis of sales by month, if you look at the image the last three months
(october, november and december/ the store opened october last year) this are along with january to august months of this year,
how can i separate these months by year on this visual? avoiding show the last months of 2021 on 2022 analisys?Sales graph by monthHow datetime is stored

/year filter works, the problem is in charts with all months of the year

[Henrykong_ · Accepted solution]

Hi @Thiago_Melo ,

Can be grouped by custom fields, current year + month. Try like below:

new_date = YEAR(test[Date]) & "-" &MONTH(test[Date])

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Thiago_Melo there are a few ways to do this, put the Year column on legends or create another column in your table called YearMonth and then create the value which is made of Year + month and then use this new column on the x-axis. 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.