Forum Discussion
Remove a filter in URL
Hello. I am trying to create a URL to my PBI report which auto-filter values according to some parameter, and I am referring to below for guidance.
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
My issue is as follow:
1. I can create a URL that auto filter a column called "Title" as per intended (great)
2. But when I want to remove the filter to look at other titles, there's no way to remove it within the report itself since the filter is still applied in the URL.
3. Therefore I cannot view other Titles.
Full list of Titles in a Slicer visual
With the filter in URL, the Slicer visual now only show this Title, no way to reset the filter to show everything again
Is there a way for me to remove the "?filter=..." in the URL aside from asking all users to erase it manually in their URL bar? Or is there any other way to show back all the Titles in the slicer?
5 Replies
Add Clear All filter button or reset filter button.
you might want to disable persistent filter from options.Hi PowerBIEnthu,
Would you be able to explain a bit on how to do the first one, to create a reset filter button?
Also, how would disable persistent filter help in my situation?
https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story#:~:text=Step%201%3A%20Open%20Bookmarks%20pane,none%20of%20slicers%20are%20selected.
Persistent filter might not be much of use in your case but here you go.
https://powerbi.microsoft.com/it-it/blog/announcing-persistent-filters-in-the-service/Making the clear all filter button did not work because the filter is applied on the URL itself. So as far as the report page is concern, it is already showing all available filters.
Clearing all filters did not work since the filter is applied on the URL itself
