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

Be 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

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

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.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.