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 in...
  • 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.