Connecting a single slicer to multiple tables

Hi gurus,

I am at a loss, and I can't seem to find a solution on line...

I have 3 separate tables (each on different worksheets) that I want to summarise in 3 pivot tables and filter by month with a single slicer.

Picture 1.jpg

Firstly, I added all 3 tables to a data model, and created a date relationship to link them all together.

pivot.jpg
Diagram.jpg
Manage Relationships.jpg

The idea I have is that I would be able to filter all 3 tables at once by month - however the slicer does not work at all. I have ensured that the slicer is connected to all three.

Any thoughts?

Thanks so much