Trying to get bar chart to show same month historically

[Fusilier2]

Hi,

I'm trying to create a bar chart that, for the current month selected (e.g. May), shows sales values for every month of May in the data: May 2018, May 2019, May 2020, May 2021, May 2022, May 2023 etc

Is this possible in Power BI?

Thanks

[Fusilier2]

Ah, OK thanks, I'll try it.

[AndrewPF]

In Power Query, use the Date.Month function to create a new variable. 

Then put this new variable into a slicer. 

Change your chart so that the X-axis is categorical rather than continuous.