Forum Discussion
Where is the documentation explaining that 'Selected Visuals' option does not retain page filters?
My sample landing page is shown below, there is a table visual displaying the Date and Sales. The slicer visual shows the Areas. There are 2 buttons pointing to bookmarks configured to perform page filter (relative date filter) for last 3 days and last 7 days respectively.
View when 'Last 3 days' button is clicked:
View when 'Last 7 days' button is clicked:
There are 2 bookmarks configured in the Bookmarks Pane:
'Last 3 days' bookmark has the following Page level filter:
'Last 7 days' bookmark has the following Page level filter:
The 2 buttons have action configured as Bookmark, as shown below.
'Last 3 days' button action:
'Last 7 days' button action:
The configuration when creating/updating the bookmark is:
Suppose the user clicks on any slicer item, then the table gets filtered showing sales for the respective area. When the user clicks on the button (Last 3 days or Last 7 days button) then the table gets filtered based on bookmark setting (page level filter). Screenshots for this are shown above. However, the slicer selection gets reset.
The problem I am trying to solve: Retain slicer selection across bookmarks. To do this I have found a workaround, as explained below:
1. Select all the visuals, except the slicer
2. Right click on the bookmark and choose 'Selected values'
3. Right click on the bookmark and choose 'Update'
4. Repeat the above for both Bookmarks
Now, when the user clicks on any button (3 days or 7 days), then the slicer value is retained. However the page level filter no longer maintains its bookmarked value. It appears that 'Selected Visuals' option does not retain (bookmark) page level filter.
Question 1: Please can you point me to official documentation from Microsoft where it is mentioned that the 'Selected visuals' options does not maintain page level filter.
The above problem (page level filter not getting bookmarked) can be solved with a workaround - as follows:
Note down the page level filter value for all bookmarks (for example: in a notepad file)
1. Remove the page level filter
2. Add a slicer visual with the required filter setting
3. Open the selections pane, select all visuals except the slicer visual, right click on the bookmark, ensure 'Selected visual' is check marked, click on 'Update'.
4. Repeat this for each bookmark
Using the above workaround we can have slicer values retained across bookmarks.
Question 2: The same problem as explained does not happen for filters applied at visual level (this is not explained in the example given above). Please can you point me to official documentation from Microsoft where it is mentioned that 'Selected visuals' option retains visual level filers.
Question 3: Whether there is any other alternative way to retain slicer selection across bookmarks?
Question 4: Whether there is any plan from Microsoft to implement a simpler way to retain slicer selection across bookmarks so that users don't have to use workarounds like this?
3 Replies
- v-xiaotang
Community Support
Hi nachiket
Thanks for reaching out to us.
During my test, neither the page level filter nor the visual level filter will be reset. When you switch the bookmark, its status is the status when you set the bookmark.
Product Version:
2.97.801.0 (21.09) (x64)Regarding your questions, I’m sorry I didn't find the relevant official documents either.
If you need more help, you can @ me.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
- nachiketFrequent Visitor
Hi v-xiaotang, I am dissapointed that you have not read my question correctly and also not tried to replicate the issue that I am facing. For example there is no slicer, no button in the screenshot you have shared.
I have mentioned that the slicer selection gets reset. Then, when you use the 'Selected Visuals' method, the bookmarked page level filter is not retained.
I requset you to please read my question again, line by line, try it out, and then give me the response.
- nachiketFrequent Visitor
v-xiaotang - is there any update on this please?