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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RGI
Helper III
Helper III

Chiclet Slicer - Persistent filters (slicer) not working

We have used the Chiclet slicer in one of our reports.
We use this particular slicer because it allows us to force the user to select one and only one element.
Screen Shot 2018-11-02 at 13.16.02.png
 
The problem is that when the users refresh their report on their phone (swiping down) it resets their slicer to the item that was selected when we published the report. When building the report the slicer selects a single element by detals (the first one on the list) - to be expected I guess.
 
Is there any way, using the Chiclet slicer, to allow the system to keep their selection instead of reverting back to the published selection? At the moment it's pretty annoying in that they swipe down and then have to re-select every time.
2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @RGI,

 

Nope, current it seems not contains options to configure 'keep filter items' when refresh.

In my opinion, I'd like to suggest you to create a bookmark with specific selection items so you can quick reset these filters.

 

In addition, you can also submit an idea for this requirement.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Following some feedback from Microsoft support we've discovered the following:

 

In order to make the filters persists you need to

1) set your filter and immediately exit the report (load another) BEFORE you do a refresh

2) come back to your report and it should have retained your selection

3) do NOT change your sheet (if your report has multiple sheets)

 

If you do the above, and as long as you keep that sheet it appears to keep your selection even if you do a swipe-down refresh.

We find that if you change your sheet anything can (and probably will) happen.

 

Apparently it's a know bug and will be fixed at some stage.

 

We were advised to wait 60 seconds after making a selection before we refreshed - waiting 60 seconds made no difference to us. Exiting immediately did - it appears that doing this allowed the system to "save" the filter state.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Kudoed Authors