Forum Discussion

ZachUnger's avatar
ZachUnger
Helper II
1 year ago
Solved

Slicer Search Select all based on comments

Hi Team 

 

I'm using a search slicer based on comments and want to know if there is an easy way to select all once the search has been completed. 

Super annoying having to select them all individually and in some cases, results can be in the 100s. 

 

Cheers 

Zach

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ZachUnger 

     

    Currently, the default slicer in Power BI cannot do this.
    Once you start a search, the Select All option disappears and only the matching options are displayed.

    You can vote for an existing idea or submit a new one at Microsoft Fabric Ideas.

     

    The following are two alternatives:

    1. Using the method mentioned in Irwan's reply

    First enable the Show "Select all" option in the slicer settings. 

    Do not enter content in the slicer's search box, in the slicer's visual filtering pane, "Filter Type" select "Advanced filtering", "Show items when the value" selects "contains", enter content here and "Apply filter". 

    This way the “Select all” option in the slicer visual will not disappear.

     

    2. Click “Get More Visuals” to add Text search slicer visual

    Enable the “Show ‘Select all’ option” in the Power BI default slicer.

    Create the Text search slicer, add the required fields, and then enter the content to search.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ZachUnger 

     

    Currently, the default slicer in Power BI cannot do this.
    Once you start a search, the Select All option disappears and only the matching options are displayed.

    You can vote for an existing idea or submit a new one at Microsoft Fabric Ideas.

     

    The following are two alternatives:

    1. Using the method mentioned in Irwan's reply

    First enable the Show "Select all" option in the slicer settings. 

    Do not enter content in the slicer's search box, in the slicer's visual filtering pane, "Filter Type" select "Advanced filtering", "Show items when the value" selects "contains", enter content here and "Apply filter". 

    This way the “Select all” option in the slicer visual will not disappear.

     

    2. Click “Get More Visuals” to add Text search slicer visual

    Enable the “Show ‘Select all’ option” in the Power BI default slicer.

    Create the Text search slicer, add the required fields, and then enter the content to search.

     

    Best Regards,
    Jarvis Tang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • ZachUnger's avatar
      ZachUnger
      Helper II
      1 year ago

      Thanks Irwan. I understand that option and have used it before but this is after searching. If my search returns a large number of results I want to be able to select all of those options that appear within the search. 

      Kind of like how it works in this space: 

       

      • Irwan's avatar
        Irwan
        Super User
        1 year ago

        hello ZachUnger 

         

        does the "Select All" option gone after bering filtered from filter pane?

         

        here i tried to make a simple example.

        if i filter the data from filter pane, it is possible to check the select all option to select all list after being filtered.

         

        Hope this will help.

        Thank you.