Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
andrewdoecke
New Member

Using select all within a slicer

Hi All

I have the multi select option on and also the search function within my slicers.

When a search value is entered, then the select all button option disappears.

Is there a way to "select all" of the search results other than holding down control and selecting all of the individual results?

Cheers

Andrew

8 REPLIES 8
Anonymous
Not applicable

You can implement an other Visual Called "Text Filter" along with the existing slicer.

Ultimate_JK_1-1724946779135.png

 

Ultimate_JK_0-1724946634946.png


This is not a direct solution, but a workaround.
This way you can search for the key words and it filters you tables/visuals

Anonymous
Not applicable

You can implement an other Visual Called "Text Filter" along with the existing slicer.

Ultimate_JK_1-1724946779135.png

 

Ultimate_JK_0-1724946634946.png


This is not a direct solution, but a workaround.
This way you can search for the key words and it filters you tables/visuals

Anonymous
Not applicable

Hi @andrewdoecke ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

 

Best Regards

Community Support Team _ Polly

 

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

Hi @Anonymous 

 

Why should the OP accept your answer as the solution?  I posted the correct answer, after I did so you posted an incorrect answer which I pointed out to you was incorrect, you then amended your answer.  And now you prompt the OP to mark your response as the answer.  Hmmmmm.

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

Hi @andrewdoecke ,

According to my test, you can select show "select all" option in Format->selection controls. then search for relevant filter results in slicer, these displayed results are selected by default. But after testing, this way does not work for visuals, which still shows the results corresponding to the select all filter.

vpollymsft_2-1667355358990.png

 

 

vpollymsft_1-1667355319201.png

 

You can also vote here: Slicer: select all from search results  and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

 

Best Regards

Community Support Team _ Polly

 

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

Hi @Anonymous 

 

If I try this the slicer shows the reduced options due to the search term (I search for the letter e) but the table is not filtered. I guess because the Select All option is still selected.   Did you do something else to achieve @andrewdoecke desired outcome?

 

srch1.png

 

srch2.png

 

regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

Hi @PhilipTreacy ,

I'm very sorry I misunderstood what @andrewdoecke 's meant. I have modified the solution. Thank you very much for the reminder.

 

Best Regards

Community Support Team _ Polly

 

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

PhilipTreacy
Super User
Super User

Hi @andrewdoecke 

 

No I don't believe there is any other way than using the mouse (or keyboard) but you have to do them one by one.

 

If you turn off Multi-Select with CTRL in the Slicer Settings you do't need to use CTRL+Mouse, just click with the mouse.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.