Connecting a single slicer to multiple tables

[Brisbanejez]

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

[rorya]

That workbook has no pivot tables, slicers, or relationships that I can see?

[Brisbanejez]

That workbook has no pivot tables, slicers, or relationships that I can see?

Well that's embarrassing. Not sure what happened there... but the updated workbook with pivots has been attached. Thanks for pointing that out Rory