Forum Discussion
How to Disable Cached Search Text in Power BI Slicers
- 1 year ago
Hi muturuf
you can use the following workaround:
-
Create a Bookmark to Reset Slicers:
- Set all slicers to their default state (no filters or search text).
- Go to View > Bookmarks and add a new bookmark (e.g., "Reset Slicers").
- Ensure the bookmark captures the Data property.
-
Add a "Reset Filters" Button:
- Insert a button on your report canvas.
- In the button's action settings, link it to the "Reset Slicers" bookmark.
- Clicking this button will clear all slicer selections and search text.
-
Use the Button Before Deployment:
- Before publishing the report, click the "Reset Filters" button to clear cached search text.
- This ensures the report starts with all slicers cleared for end-users.
Currently, manually resetting slicers using bookmarks is the most effective method to address cached search text in slicers.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
-
- Anonymous1 year ago
Hi muturuf ,
As VahidDM said, I did the test and please follow the following steps:
1. You could select the “clear all slicers” in Buttons and if you are the latest Power BI Desktop (Please check the step 5 directly if you match this condition):
2. If you cannot create the button directly, please create a bookmark of the page when none of slicers are selected:
3. Create a Button and you can configure the button to show text:
4. Set the Action property of that to bookmark and select the “clear all slicer” bookmark for it:
5. We could use Ctrl+Click on the Power BI Desktop to test the solution:
If you Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi muturuf
you can use the following workaround:
-
Create a Bookmark to Reset Slicers:
- Set all slicers to their default state (no filters or search text).
- Go to View > Bookmarks and add a new bookmark (e.g., "Reset Slicers").
- Ensure the bookmark captures the Data property.
-
Add a "Reset Filters" Button:
- Insert a button on your report canvas.
- In the button's action settings, link it to the "Reset Slicers" bookmark.
- Clicking this button will clear all slicer selections and search text.
-
Use the Button Before Deployment:
- Before publishing the report, click the "Reset Filters" button to clear cached search text.
- This ensures the report starts with all slicers cleared for end-users.
Currently, manually resetting slicers using bookmarks is the most effective method to address cached search text in slicers.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!