Help needed with Pivot Chart not showing on slicer

[Rebecca Westmoreland]

I have a workbook that I have created three different file with three different pivot charts. I created one slicer but the when I do the report connections only one pivot chart shows up. Can someone help me figure out how to connect the other two pivot charts? I have attached the file below.

I would appreciate any help.
Thanks,
Rebecca

 

[Chihiro]

Hi, welcome to the forum.

In order for slicer(s) to connect pivot tables, one of following must be met.

1. All Pivot Tables share same source data.
2. All source tables are linked via data relationship (in data model).

Since, you have neither of above condition met, slicer cannot connect tables.

I'd recommend using PowerQuery & PowerPivot to accomplish this. However, if that's not feasible, you could use data relationship outside of PowerPivot (Excel 2013 & 2016).

What version of Excel do you have? And what license SKU?
Best fit solution will largely depend on it.

Edit: Have a read of following article series. If you've never used PowerPivot.
https://algconsultings.wordpress.com/2010/05/28/why-microsoft-powerpivot/

 

[Rebecca Westmoreland]

We have Microsoft 2016.

 

[Chihiro]

Then you can use data relationship without using PowerPivot. Or alternately you can combine all tables into one fact table using PowerQuery (Get & Transform).

Have a read of links for how to use data relationship.
https://www.techrepublic.com/blog/10-things/10-steps-to-using-excel-2013s-new-data-modeling-feature/
https://support.office.com/en-us/ar...in-Excel-fe1b6be7-1d85-4add-a629-8a3848820be3
https://www.intheblack.com/articles/2015/10/01/easy-steps-to-make-data-relationships-work-in-excel

 

[Rebecca Westmoreland]

I appreciated the assistance. I think I know what I can do to fix it now.

You all are awesome!
Thanks again,
Rebecca