Forum Discussion

muturuf's avatar
muturuf
Frequent Visitor
1 year ago
Solved

How to Disable Cached Search Text in Power BI Slicers

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 se...
  • VahidDM's avatar
    1 year ago

    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 

  • Anonymous's avatar
    Anonymous
    1 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.