Skip to main content

Power BI

Needs Votes

Slicer Search - Add "Select All Results" option

Vote (670) Share
's profile image

on 30 Aug 2016 03:43:23

The basic Slicer in power bi already has a search feature. My request is to add a way to select all search results in one click. For example, say I search a text column in the slicer for all values with "ipad" and I get 200+ results returned in the slicer. It would be super helpful if you could select all 200+ results in one click since selecting one-by-one is so tedious.

Comments (117)
's profile image Profile Picture

1190f0ed a8db-46a2-883d-8d085e112812 on 05 Jul 2020 23:07:15

RE: Slicer Search - Add "Select All Results" option

I was so frustrated. Now i know it's missing in the design. We need this!

's profile image Profile Picture

1f01e070 45e1-472b-bab7-05c477366026 on 05 Jul 2020 23:00:02

RE: Slicer Search - Add "Select All Results" option

Just ran across this limitation. *insert facepalm gif*

's profile image Profile Picture

2cc212fc 6d83-498b-bdbc-184ef0bab2f0 on 05 Jul 2020 22:57:06

RE: Slicer Search - Add "Select All Results" option

I agree, when you have a list with hundreds or even thousands of lines of data, and you run a search, you still might come up huge amount of search results and manually selecting the box for each one is not practical.

Remember that in Excel with tables or filters, this option is already available. When you click the down arrow for a particular column the top box says "(Select All)", when you input search criteria, the top box changes to "(Select All Search Results"). This is exactly what we need on the Slicer Search.

's profile image Profile Picture

ab9a76b7 35a7-4ff0-9723-b15ab49a52d0 on 05 Jul 2020 22:52:58

RE: Slicer Search - Add "Select All Results" option

This is a desperately needed and completely obvious feature. Without this feature the search function is very limited. Imagine a part number search where 5P4 returns 300 results. The user is supposed to click 300 times?

's profile image Profile Picture

0651c2b2 1e4d-465c-8d27-2d949ec96e26 on 05 Jul 2020 22:44:55

RE: Slicer Search - Add "Select All Results" option

I agree. This idea would vastly improve the currently slicer search configuration.

's profile image Profile Picture

430927ab de11-47ba-a0d5-7b71588ee6ac on 05 Jul 2020 22:42:39

RE: Slicer Search - Add "Select All Results" option

As far as I can see now there are three other Ideas that adress this request:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17636017-dropdown-search
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17456218-slicer-improvement-with-search-and-select-all
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17054293-select-all-when-using-slicer-search

It would by nice the have this feature. You would think that when you activate 'Select all' for a dropdown or list slicer, it would also be available after you Search/ filter your options.

....but it it would also be nice to somehow combine the ideas & votes into one request (or link them). It's difficult to vote of you have 4 similar options.... (i think combining/ relating similar Idea's is better in general)

's profile image Profile Picture

b40fc76b 9eca-4ea0-89a9-95c920fd6526 on 05 Jul 2020 22:33:26

RE: Slicer Search - Add "Select All Results" option

It is a much needed feature without this the search is really not usefull, as your search result may bring a big list which today has to be manually selected.

Please add this.