Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
You can implement an other Visual Called "Text Filter" along with the existing slicer.
This is not a direct solution, but a workaround.
This way you can search for the key words and it filters you tables/visuals
You can implement an other Visual Called "Text Filter" along with the existing slicer.
This is not a direct solution, but a workaround.
This way you can search for the key words and it filters you tables/visuals
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
Proud to be a Super User!
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.
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?
regards
Phil
Proud to be a Super User!
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.
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
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 35 | |
| 34 | |
| 27 |
| User | Count |
|---|---|
| 134 | |
| 101 | |
| 71 | |
| 67 | |
| 65 |