Getting a slicer that contains a single list of PMs and PDs

[trower]

We have a project table, each project has a project manager and a project director.
What I would like is a slicer that has all the project managers and project directors listed on it (some people are both project managers and project directors). When a name is clicked on the list I would like the pivot table to be filtered such that it shows the projects that the person is either project manager or project director of.
Can someone point me in the right direction?
Thanks
Paul

 

[scottsen]

By default, power pivot will "just do that" -- assuming you have correct relationships setup in your model.

 

[Tianbas]

You need a name or better people ID column in a new table that includes both PMs and PDs. Create relationships between your PM data and that column and your PD data and that column. If you now use that column as a slicer power pivot will "just do that" as scottsen said