Skip to main content

Power BI

Completed

Searchable Slicer

Vote (1226) Share
Colin Alan Macguire's profile image

Colin Alan Macguire on 15 Sep 2015 18:48:51

It would be great if slicers were searchable. Many times the list of possible items people can slice by is large, and having to scroll till you find the value(s) you are looking for is tedious.

Please enable slicers to be searchable (much like what Qlik has been allowing for years already).

Thanks.

Administrator on 02 Aug 2016 04:46:53

Searchable slicers are available now in Power BI! Make sure you're on the June release or later of Power BI Desktop. You can find the search box by clicking the "..." menu on the slicer visual and selecting search.

Comments (73)
Colin Alan Macguire's profile image Profile Picture

fefc3c10 1f7c-4e98-b42a-0346273efbb6 on 05 Jul 2020 22:25:17

RE: Searchable Slicer

So i think this is now on the latest version of the desktop. I can now search and it reduces the result set based on my search; however, is there a way i can search and simply press "Return" to pick everything that comes back? I don't want to highlight each record in the result set manually when what i want is all of them. Basically the same behavior of an Excel slicer. Thanks again for the rapid development.

Colin Alan Macguire's profile image Profile Picture

701ad3fb 942b-4a1d-ad84-14806f619b12 on 05 Jul 2020 22:25:17

RE: Searchable Slicer

Looks good in the June release. It would be great if the text entered could be easily cleared by pressing the eraser button rather than having to backspace to remove the text.

Colin Alan Macguire's profile image Profile Picture

411b7afe 9973-4dd6-8e94-3f18ab386d70 on 05 Jul 2020 22:23:36

RE: Searchable Slicer

I agree that searchable slicers is a must. But please also add ability to sort a slicer descending by a measure and to show only top x.

Colin Alan Macguire's profile image Profile Picture

3f22f54c 2e70-4e21-b4bc-9dcd79a4f87d on 05 Jul 2020 22:23:25

RE: Searchable Slicer

If you are interested in this feature, you should try SmartFilter http://okviz.com/smart-filter
Feedback is welcome!

Colin Alan Macguire's profile image Profile Picture

a294afaa b48a-4ca1-8617-298cd42b9f88 on 05 Jul 2020 22:22:21

RE: Searchable Slicer

How close is this fix to being fully executed?

Colin Alan Macguire's profile image Profile Picture

7b6630a4 f50b-43d9-83d3-76a0b431e4b1 on 05 Jul 2020 22:22:20

RE: Searchable Slicer

One vote more.... Please add this!
It is frustrating to present your dashboard only to hear the users ask why they can't do it. "Just like Excel" is the first reaction :(

Colin Alan Macguire's profile image Profile Picture

2d0dda33 c05c-4e94-a8f5-a80f9275fa92 on 05 Jul 2020 22:22:11

RE: Searchable Slicer

This is huge and very welcome! Are you (or is anyone) able to set our expectations on timing?

Colin Alan Macguire's profile image Profile Picture

6f1803f0 bcfe-4e20-bd6e-ee36a3e5275f on 05 Jul 2020 22:22:11

RE: Searchable Slicer

This feature would greatly accelerate our needs as are customer list is quite extensive.

Colin Alan Macguire's profile image Profile Picture

684018db ade1-41f5-8c81-be001fdb533f on 05 Jul 2020 22:21:50

RE: Searchable Slicer

Awesome news! It'd be nice to have a dropdown/picklist type of slicers too. Makes the real-estate management a lot easier and the reports will look much more pleasing. Please vote here if you like such an idea(not mine): https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13347174-dropdown-component#comments

Colin Alan Macguire's profile image Profile Picture

431581a6 37a5-4ca4-bafe-46baf59d7e7a on 05 Jul 2020 22:21:38

RE: Searchable Slicer

Eagerly waiting for this !!. Very important feature.

Many thanks

Joe Natarajan