Slicer Search Select all based on comments

[ZachUnger]

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

[Anonymous · Accepted solution]

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]

This worked perfectly! thank you! 

[Irwan]

hello @ZachUnger 

is it possible to toggle ON "Select All" option?

Thank you?

[ZachUnger]

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]

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.

[ZachUnger]

Yes I have that selected but it doesn't help with this unfortunately