Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

sync two filters in Power Pivot Excel

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?

Need Help
  • rbriga's avatar
    rbriga
    4 years ago

    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

     

2 Replies

  • rbriga's avatar
    rbriga
    Icon for Impactful Individual rankImpactful Individual
    4 years ago

    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