Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
mpataki32
Helper III
Helper III

Date slicer remember the last selection's of the user

I have a date slicer as it shown below, next to the slicer there is a toggle and with that the users can select the current month (solved via bookmarks). 

mpataki32_0-1702723016093.png

 

mpataki32_1-1702723533796.png

 

The problem is that the users requested from me that the selection of the period should be remembered in the date slicer when they activate the toggle and deactive, for example: 

 

1. Toggle is off, date is selected:  

mpataki32_2-1702723680134.png

2. Toggle is on and showing the current month: 

mpataki32_3-1702723714031.png

 

3. Click once again on the toggle, to deactive it, but it is resetting the date slicer even though they would like to see the selection of 2022: 

mpataki32_4-1702723776186.png


Is there any way to solve this? I would avoid to setup multiple bookmarks (to create duplicates of the visualization and hiding/showing them) because of the amount of visualizations. 

I explained that multiple times to my product owner that this is normal behaviour of the slicer and it is needed to not to have the scenario to cross-filter the data, but it looks like a must have requirement.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Tell them that their must have requirement is impossible.  You have already identified a potential workaround that has a high maintenance cost. 

 

Power BI does remember the filter settings on a per user basis, but only one for each filter (if you allow it, via a cookie).  You are being asked to provide freely addressable history for each filter and user - not something that is likely to ever be implemented.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Tell them that their must have requirement is impossible.  You have already identified a potential workaround that has a high maintenance cost. 

 

Power BI does remember the filter settings on a per user basis, but only one for each filter (if you allow it, via a cookie).  You are being asked to provide freely addressable history for each filter and user - not something that is likely to ever be implemented.

I was thinking about to create a kind of custom visualization with JS, but the more I think about it I'm realizing that it not only requires high maintenance, but I have a feeling that probably it will cause some kind of conflict between the PBIS and the custom visualiztion, because of the cookies (as you mentioned) as well and in the end it we are going to have some kind of security issue as well.  

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.