How to Disable Cached Search Text in Power BI Slicers

[muturuf]

Hi All,

In Power BI Desktop, is there a way to disable the caching of search text in slicers? During development, I frequently use slicer search on multiple slicers, but Power BI retains these search entries. Before deployment, I have to manually clear each slicer’s cached text to prevent any unintended filters, which is easy to overlook.

Thank you in advance.

[VahidDM · Accepted solution]

Hi @muturuf 

you can use the following workaround:

1. 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.

2. 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.

3. 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!! 

LinkedIn|Twitter|Blog |YouTube 

[muturuf]

I see. thank you both very much.

[v-xinc-msft · Accepted solution]

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.

[VahidDM · Accepted solution]

Hi @muturuf 

you can use the following workaround:

1. 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.

2. 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.

3. 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!! 

LinkedIn|Twitter|Blog |YouTube