Forum Discussion

mizaskun's avatar
mizaskun
Helper II
4 years ago

Sync two unconnected slicers

Good morning! 

 

Is there any way I can sync two unconnected slicers which are located in different tabs under the same report with the exact same values? The model architecture does not allow to connect the tables.

 

Thank you so much!! 

3 Replies

  • That's not what "sync slicers"  means. To sync slicers you create the slicer on one tab and then copy/paste it to another tab. 

     

    Maybe explain what you are trying to achieve?

  • DataBlau's avatar
    DataBlau
    Frequent Visitor

    Here's how to do this.

     

    1. Start with only one of the two slicers you're needing to create added onto your page.

    2. Add a blank page

    3. Copy the slicer to the blank page; select "Sync" in to popup window

    4. Open the Sync Slicer pane from View in your ribbon

     

    5. Click on your slicer on the new blank page

    6. In the Sync Slicer pane under Advanced options uncheck "Sync field changes to other slicers"

    7. Update the slicer on the blank page to the other field you want your two slicers to sync to

    8. Copy the slicer on the blank page (with the updated field) to your original page with choosing "Sync"

    9. You're two slicers (with two seperate fields) should now match exactly and stay that way when changing the filtering

    10. (optional) Open up the Selection pane and hide one of the two slicers; since they're the same one can be hiden