One Slicer for Two Different Datasets in Excel | Relationships | POWER PIVOT | Dashboard Reporting

[@virgilletsie5426]

Thank you so much. You have no idea how this my my job easier

[@tademustapha4954]

This is brilliant!!! Thank you

[@ExcelBasement]

You're so welcome!

[@1760Andy]

Nice...

[@leanna8560]

I use Macbook and I did not find the Relationships function, how can i fix it?

[@blizzardr6980]

Is there any way to do this so a slicer filters 2 different tables of data - not pivot tables (they both have the same data in but I want to be able to filter different parts of my dashboard by different things)