Skip to main content
Microsoft Idea

Power BI

Needs Votes

Slicer Search - Add "Select All Results" option

Vote (1294) 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 (201)
's profile image Profile Picture

Adam Kruzel 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

Jim Cush on 05 Jul 2020 22:59:31

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

This is the one item that is keeping me from migrating SSRS reports to Power BI: We have parameters that are set up to return results that contain inputted text. For example: Show all titles that contain the word: Space
1. This will return all titles that containing the letters 'space' (non-case sensitive)
2. WIll allow you to 'Select All' as there may be a LOT of results that you want to see
3. This is dynamic for the user on the RS Server, NOT hardcoded in DAX

's profile image Profile Picture

Charlie Jewkes 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

Charlie Jewkes on 05 Jul 2020 22:57:06

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

Please vote for same search request at this link:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15858583-slicer-search-add-select-all-results-option#comments

's profile image Profile Picture

Charlie Jewkes on 05 Jul 2020 22:57:06

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

Please vote for same search request at this link:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15858583-slicer-search-add-select-all-results-option#comments

's profile image Profile Picture

Charlie Jewkes on 05 Jul 2020 22:57:06

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

Please vote for same search request at this link:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15858583-slicer-search-add-select-all-results-option#comments

's profile image Profile Picture

Björn Kvarnström on 05 Jul 2020 22:57:05

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

Should be as simple att hitting the Enter button after searching

's profile image Profile Picture

Craig Lathrop 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

Sean 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

DvG 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)

Merged Idea (11)