Connect Two Pivot Tables Created from Different Data Sources using Bridge Table
This video shows how to connect two Pivot Tables or Pivot Charts to one slicer wherein the two Pivot Tables are not from the same data source. This video shows how to use Power Query to connect the two tables and create and connect a bridge table that acts as the connecting table between the two tables. This is because the two tables do not have a field that will connect them because of duplicates in the connecting field.