pivot slicer connect to another set of data

This is where you can use Power Pivot to join your data.

Format your source data as tables, and use Power Query to load the data to the data model:

Table1:

Please Login or Register  to view this content.

Table2:

Please Login or Register  to view this content.

Add a third query to get all the distinct Team values, in a third table.

Teams:

Please Login or Register  to view this content.

Close and load all three queries: "Only Create Connection", and tick "Add this data to the Data Model".

Now in PowerPivot create a relationship between the tables, on field Team:

xlf_1279619.png


Now you can create your pivot reports from your Data Model tables. Add a slicer using field 'Team' from table 'Teams', and connected that slicer to both pivot tables.

See attached workbook for a worked example.