Pivot Table Dashboard

Hello Group members,

I am a new member in this group and have the following question on creating a dashboard from pivot tables.

I have three sets of data as follows

dataset 1
Region Connectivity Scenario 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
USA Embedded Opt 1,500 1,600 1,700 1,800 1,900 2,000 2,100 2,200 2,300 2,400 2,500
Europe Tethered Pes 1,000 1,100 1,200 1,300 1,400 1,500 1,600 1,700 1,800 1,900 2,000
China Smartphone SBD 2,500 2,600 2,700 2,800 2,900 3,000 3,100 3,200 3,300 3,400 3,500

dataset2
Region Connectivity Scenario 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
USA Embedded Opt 1% 11% 21% 31% 41% 51% 61% 71% 81% 91% 101%
Europe Tethered Pes 5% 15% 25% 35% 45% 55% 65% 75% 85% 95% 105%
China Smartphone SBD 11% 21% 31% 41% 51% 61% 71% 81% 91% 101% 111%

I created individual pivot tables on new sheets and then created pivot charts for the dashboard. How do I insert common slicers that allows me to manipulate both the tables i.e. if I filter for region, I would like to see both the charts change for the chosen region.

I have about 10 different datasets that I would like to add to this dashboard. Any suggestion and help on how to do this would be great. I looked at data models and adding relationships tables but it does not work as it does not allow me to create new tables.

Looking forward to hear from team members.
Vishnu

Try this: Click on the header of a Slicer, then click on Options, and then PivotTable Connections. Then check mark all of the pivot tables you want to be controlled by the Slicer.