Forum Discussion
Persistent Filters are TOO persistent
Microsoft rolled out a fix for me this month that may work for others with this issue. If you go to the reports page and click the gear icon for the report you will now see a toggle switch to disable retained filters. Took a while but I am now able to disable these filters on satelite reports. Thanks Microsoft!
Thank for the suggestion gooranga1 it would be time consuming but Microsoft seems to be leaning towards the delete and republish path. I have a few large datasets that support about 75 reports. That would take several weeks for me to republish all of them with the customizations that have been added to them on the service since they were built. That is a year or two of work, in some cases, that would need to be recreated.
Does the custom visual need to be on each report page or just one per report?
Hi kcantor,
It seems as long as there is at least one custom visual anywhere in the pbix we don't get the slicers being saved in their previous state and the Reset to Default button never gets highlighted for these pbix reports.
I am going to toss one in and see if it will work. Has to be easier than recreating all of those reports.
Unfortunatley, this does not solve the problem. I will disable the retaining filters in the original report, which I could do in the data model but does not fix the satelite reports. Even if I navigate to the reports and add a custom visual there, it still tries to retain filters.
I tried three different custom visuals. Is there one in particular it refuses to work with?
Hi kcantor,
Sorry to hear it's not working. I just checked the pbix files that this works for one has a custom visual called 'Attribute Slicer'.
I just tested a pbix file in development at the moment and I added a mapbox visual which has just altered the functionality of that with filters and it no longer doesn't have persistent filters. A f5 simply resets all the paramters back to original settings.