PivotChart Filter Question

[gmazza76]

Good morning,

I have 2 pivot charts running from PowerPivot and am wondering if it is possible to link 2 filters?

In both PivotCharts I have the same filter that shows to different views for data, but is there a way that I only change 1 filter on the first PivotChart and it automatically updates on the second PivotChart.

I have looked online and everything is showing for Pivot Tables.

Thanks
Gavin

 

[GraH]

Maybe, you can use a slicer connected to both pivot tables.
Look for report connections on the Slicer context ribbon, section "Options".

 

[gmazza76]

Thanks, this worked

 

[GraH]

Glad I could help. Thanks for the feedback and marking as solution.