sync two filters in Power Pivot Excel

[prakash11440278]

Hi All,

Is it possible to sync two filters in power pivot excel sheet? I know this can be done in power bi desktop but i want to do the same operation in power pivot excel. Please suggest how to acheive this?

[rbriga · Accepted solution]

It's possible- and really easy!

Assuming you have a pivot table\ chart on sheet 1 and another on sheet 2 and you want to slice by [Year]

1. On sheet 1, under the PivotTable menu, select "insert slicer" and pick the slicer on [Year]
2.  Slice to the year you wish
3. On sheet 2, under the PivotTable menu, select "insert slicer" and pick the slicer on [Year]
4. On sheet 2, under the PivotTable menu, select "filter connections"
5. Tick the slicer in sheet 1

Your slicers are now synced.Sync the slicer on the other sheetAdding a slicer and syncing

[Anonymous]

Hi @prakash11440278 ,

Please review the content in the following links and check whether they are what you want. 

Synchronizing PivotTable Filters without using VBA

Filter Multiple Pivot Tables With Excel Slicers

More Than One Filter on Pivot Table Field

If the above ones can't help you, you can try to raise a ticket in Excel community.

Best Regards