The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!!
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
Hi @mizaskun ,
Could you please share some sample data and your expected result with backend logic and special example screenshot in order to provide you a suitable solution? Are these two slicer options from same field?
Sync slicers across pages in Power BI reports
SYNC SLICERS & SYNC SLICERS ADVANCED OPTIONS
Best Regards
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?