Top N when year changes

[hans3400]

Hi

I have a bar chart that shows how many invoices is being created on a monthly basis. I have a data set that goes back to Jan 2022. 

I only want to show the last 5 months in the report and so far it has worked fine. I have added the number for Jan 2023 and now the bar chart adds Jan 2022 and Jan 2023 together which is not what I want. I want it to show Sep, Oct, Nov, Dec and Jan which is the last 5 months. How can I do that?

Bar chart is set up this way: 
X-axis is month (value of date column is written like this: 2022 01, 2022 02, 2022 03 etc.)

Y-axis is number of invoices

Filter on date (month): Top N: Top 5 by value Latest Month.

I hope someone can help. 

Cheers

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=inJ3Yt7ay30

[hans3400]

Thank u for taking the time to help me! 🙂 

I have watched the video but it involves a lot of different slicers which is not something I want. I'm new ti PBI, so maybe I'm missing the hint in the video.