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

2eab7d01 b9a4-461e-8338-d495a577c330 on 05 Jul 2020 22:16:51

RE: Searchable Slicer

Search should be keystroke based... once "a" has been typed only items starting with "a" should be displayed.

Colin Alan Macguire's profile image Profile Picture

07595cb9 356f-4caa-a832-71bd1de8fc4a on 05 Jul 2020 22:16:44

RE: Searchable Slicer

All my clients are asking about this ability.
A "must have" feature !

Colin Alan Macguire's profile image Profile Picture

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

RE: Searchable Slicer

Hi Power BI team !

We are currently forced to use multiple slicers ie a single character slicer , followed by a first 2 character slicer followed by a first 3 character slicer to filter a field which is time consuming & difficult. It will be great if this could be fixed. Many thanks

Colin Alan Macguire's profile image Profile Picture

ed1eae5d 3413-41a7-8616-cbec8d7aba4d on 05 Jul 2020 22:15:59

RE: Searchable Slicer

Tableau also has this and it has been a major pain point in reports and demos of measures with more than a dozen members. Definitely will try the Index workaround!

Colin Alan Macguire's profile image Profile Picture

034519ac 4ff6-4157-bd15-2f889d260205 on 05 Jul 2020 22:15:56

RE: Searchable Slicer

Definitely needed!

Colin Alan Macguire's profile image Profile Picture

a33aaa92 29ff-4b94-a178-8eedb6c46ecb on 05 Jul 2020 22:14:32

RE: Searchable Slicer

My client can't depend on a slicer to search for the specific object in a database of 3,000,000 objects. Certainly it would be a life saver to add a search feature as it would open and breakthrough to market and make tons of users really happy.

Colin Alan Macguire's profile image Profile Picture

519c998b 1e8b-4d67-aa05-4768fc92819e on 05 Jul 2020 22:14:10

RE: Searchable Slicer

This would be a welcome addition to PowerBI. Now a slicer list with all employees is not usable.

Colin Alan Macguire's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:13:55

RE: Searchable Slicer

Often slicers are used to show detailed reports for a specific product. To search for a specific procuct would be very helpful.

Colin Alan Macguire's profile image Profile Picture

b3dc47db 85d7-4e4c-92af-9af6c3b73478 on 05 Jul 2020 22:13:52

RE: Searchable Slicer

I would also like this feature - sometimes our slicers are VERY long and search would really help

Colin Alan Macguire's profile image Profile Picture

51603fe4 14c0-455d-9082-11f708c9df9c on 05 Jul 2020 22:13:37

RE: Searchable Slicer

For me this feature will be an must-have for Power BI. I've a dataset with over 50.000.000 records, in a slicer I keep scrolling! A search field for a slicer will be very usefull!