Power BI

Completed

Searchable Slicer

Vote (1226)

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)

Comments (73)

95697da6 d228-4cea-8c68-5914914d0c3d on 05 Jul 2020 22:34:47

RE: Searchable Slicer

Needs to emulate the excel search function have search and multi selections

d81b7996 c8ce-4b25-9239-71253950aee5 on 05 Jul 2020 22:34:20

RE: Searchable Slicer

For some reason this feature is not working properly on my SSAS cube. I've created a slicer and added the search bar, but if I type anything (letter or number) in, nothing is found. If I click on an item in the slicer, and then type anything in the search bar it finds just that 1 item, even if the text has nothing to do with that particular item.

4133d0ca 65e2-4fa9-acb1-a84675ba8aa9 on 05 Jul 2020 22:32:13

RE: Searchable Slicer

This should also not be marked as "Completed" without support of the "Select All" control. As implemented, the "Select All" option disappears when search criteria is entered.

When the Select All control is enabled, the "Select All" checkbox should NEVER be hidden! When search criteria is entered, "Select All" should select all items that match the current search criteria.

For Example: Searching for "Diabetes Mellitus" in an ICD-9 code Slicer displays 32 diabetes mellitus diagnosis codes. Checking the "Select All" checkbox should select all 32 diabetes mellitus codes without selecting any hidden ICD-9 codes that don't match the search criteria.

689cde87 fdd4-4341-8a1b-1ed49df05acf on 05 Jul 2020 22:29:29

RE: Searchable Slicer

I agree that this should not be completed without the ability to search for numeric values as well. I have a slicer of work order numbers that i want to be able to search in my slicer. I can't do this yet. Please add this feature.

Thanks Kim

7a521a13 45be-4ab3-9818-e5859573b464 on 05 Jul 2020 22:29:18

RE: Searchable Slicer

This is great! Thanks

a8d753f9 9c9a-44be-91af-28962531298a on 05 Jul 2020 22:27:41

RE: Searchable Slicer

If using the mobile app I've found that clicking the search box on the slicer results in my phone's on-screen keyboard obscuring 90% of the report including the search box I'm entering into. If the app could display the reports in portrait then I suspect this wouldn't be such a problem. Having it fixed in landscape mode is fine for larger screens but its very limiting when using an average sized phone.

bc62dee1 22de-4786-bbea-8990ab94247a on 05 Jul 2020 22:27:28

RE: Searchable Slicer

Awesome!

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

RE: Searchable Slicer

Hello Kim,
Thanks for adding this very important feature.
I have 2 question about it :
1. why can't we search on an non text data type.
2. After finding my searched results in the slicer list, is there a way to select all instead of manually select them ?

thanks

b9d2b14d d92c-4b94-bc54-ef217241dcd2 on 05 Jul 2020 22:26:40

RE: Searchable Slicer

I am not seeing this, could you provide a bit more detail please? Thank you.

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:25:49

RE: Searchable Slicer

June update look good, mark as Completed.