Creating one bar chart with CY and (any PY - selected in Filter) on X-axis

[Sam7]

Hello,

I have created two date tables, one for the actual date and the other to allow the end user to compare actual with any year/year-month etc

This works below

Now I want to put the results at month level on one clustered bar chart.  When I use my two measurs above it doesn't as I took the x-axis as from Actual Date table.  

How do I create bar charts, with the x-axix being months, but the months to be linked to the years chose in the slicer?

Thanks

[Sam7]

Thank you. This doesn't work as in the video, I want the x-axis to have MONTH and ANY YEAR SALES and COMPARER YEAR SALES selected to show in one bar chart. 

I do not know how to get MONTH thats linked to both date tables to show. Metric other than date work, but not date as this my SUM Measures are linked to the FILTERS of Actual and Comparer. 

[amitchandak]

@Sam7 , You need one slicer on an independent table.

refer

Power BI Abstract Thesis: How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg