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!
Hi kcantor,
Not sure if this will help or not but if you have a non standard visualisation anywhere in your pbix the persistent filters won't work at all. We have a few pbix files and they never get the 'Return to Default' button highlighted. Maybe if you add a non standard visualisation somewhere it would be a (not very nice and even more time consuming) workaround for the time being?
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?