March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Purpose: Synce slicer across Bookmarks.
Background: I would like my date slicer to sync across bookmarks. In the below example I selected Q3 as my time frame in the "Everyone" bookmark. However, when I go to the "Mountaineering" bookmark my time frame selection is removed.
Can slicers sync across bookmarks and pages? Or only pages?
Solved! Go to Solution.
Slicers sync across pages, not bookmarks. That being said, it is possible that perhaps if you turn on selection controls that you may be able to achieve your desired result. My thinking is that perhaps you can save your bookmark without cross filters and then perhaps your synchronized slicers might work and not get their values removed by the bookmark.
Slicers sync across pages, not bookmarks. That being said, it is possible that perhaps if you turn on selection controls that you may be able to achieve your desired result. My thinking is that perhaps you can save your bookmark without cross filters and then perhaps your synchronized slicers might work and not get their values removed by the bookmark.
@Greg_Deckler I am trying to resolve the issue. I am also trying to understand what you meant by "if you turn on selection controls that you may be able to achieve your desired result. My thinking is that perhaps you can save your bookmark without cross filters and then perhaps your synchronized slicers might work and not get their values removed by the bookmark." Thanks!
I am still having trouble with it.
I am not sure how to make it work with options you have indicated:
Do I have to create additional Layer (Selection) to make it work?
The issue is that if I try this way, "Hidden" layer would not stay if I move Bookmark around.
I have posted my Pbix file here if you think it is needed.
Thank you!
I want to have a "between dates" slicers updated when click a bookmark that changes the date range in the slicer on another page. The two slicers are synced but the date range doesn't update on the second page. I can't just deselect the date because the bookmark takes it back to default and I can't uncheck data because data is what I'm changing. Any ideas?
It Worked!
I unselected Data from each of my bookmarks. Then made sure that my filter was synced to the page with my book marks applied. In the below example my page is called "Product Line Variation".
Now when I select a quarter it is carried across my bookmarks!
Thast's Right.. It works perfectly when you use Bookmark as "Selected Visuais" checked., 3dots (... ) Options
DON'T SELECT SLICERS only the visuals envolved on the boook and even hidden visuals. Actually the Power B.I needs to understand all objects are affected (Shown or Hidden).
It worked.
Sweet! I thought that might work!! 🙂
My Bookmarks have charts and matrices on them. When I de-select data for any bookmark, my matrices and charts lose their filters? The Filter/Slicer does sync but visuals lose their original settings? Any ideas?
OK, here's a thought, what if in the selection for your bookmark, you choose "Selected Visuals" instead of "All Visuals" and don't select your slicers?
works fine.... but what to do if i want to see the slicers as well... but the selection has to be what i made in page 1(sync)
Same result. Sent you a private message for possible webex/screenshare to resolve.
Thank you for reaching out. No I do not have a solution. The main issue is that Bookmarks are still in preview mode while Synch Slicers is in Production. One of my colleagues just attended the annual Microsoft PowerBI Summit in Seattle where they spent a good bit of tie on Bookmarks. It was mentioned that Bookmarks moving to Production would be in the September or October release. I am hoping this is true and happens!
Hello !
I may have a solution in order to sync slicers across bookmarks.
Actually, I've made a lot of trials.
Sorry by advance if my translation is not correct cause I do not use the english version of PBI so I just translate word-for-word of French.
So, when you are on your page, open the Bookmarks tab on your screen.
Right clik on your first bookmark :
- Data must be selected
- View must be selected
- Actual page must be selected
- Unchek All visuals
- And chek Selected visual
But do not move, it's not finish.
Press CTRL+A (all of your visuals are selected) and deselect just what you want to be Sync, so deselect your filters. Everything else have to be selected.
Then, right clik on your Bookmark and "Update".
Do the same on all of your bookmarks. Then, everything should be fixed.
Hopefully that answers your question.
Have a nice day !
the respective filters will also sync?
Hi, This is working fine for me except that i am not able to see the slicer on the page(obviously because I am updating the bookmark with selected visual.) but i want to see the slicer as well but with the selection i made in the parent page. how to achieve this?
requirement:
1. I have 3 date slicers with 3 bookmarks in page1.
2. I need this arrangement(three buttons and depends on selection the date slicers appear.) on all my pages
3. the date slicers have to be in sync in all the pages(i.e. if i select 6/7/2021 in page 1 other pages also must be filtered with the same date and the slicer has to show me tht date.)
but the issue i am facing is, whenever I click on the button in other pages, the date slicer is updating as per bookmark unlike the slicer in the other page.
if i uncheck the data in the bookmark, the page is not filtered as per selected date.
if i select selected visuals the functionality is working fine i.e. the page is filtering as per my slicer selction in page1 but i am unable to see the slicer.
can someone help me please
Hi @Anonymous ,
Thank you for your solution. However if I keep my slicers retained, my page filters data associted with each toggle button are not working. Could you please check and see if I am missing something?
Here is the business use case:
End-user would like to select specific regions and venues and see sub-rental expense, purchsaed expeses and other types of expenses for selected regions and veunes.
My approach is:
1. add Regions and Venues filters
2. create three toggle buttons to intereact show corresponding data (Note: as I am using Live connection, I am not able to group each expense item into , so what I did is to create three bookmark to show each type of expense by applying PAGE FILTER)
For example, I applied filters to filter out other types of expense and bookmark it. Same as Sub-rental and Purchased expenses.
3. create three buttons to link to bookmarks to these types of expenses.
4. Select visuals and exclude "Regions" and "Venues" filters , then update the bookmark.
However, it turned out filters remain the same in different bookmark, but my page filter also remain the same , which should not. as three pages for three filtered set of expenses...
could you plesae check ? Appreciate your help ahead!
I also attached my screenshot for your review.
Jailene
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
170 | |
145 | |
90 | |
67 | |
58 |