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).
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.
I do not see this feature now.
am using Power BI Desktop for Report Server Jan 2019 Release
Has this feature been removed?
Brent Leslie commented
This is great, but there is one bug. In order for users to see the search box once the report is published, you must toggle the "... - Search" on EVERY slicer BEFORE it is published. Else the user viewing the report in an App has no way of clicking search. Not sure if this is by design, but it feels buggy.
It is a great feature. Tks.
This is great but we need to SELECT ALL once the list is filtered by our key word in the search box
Also possibility to look for more than 1 word!
Where is this feature now? Did you disable this function again?
Scott Futryk commented
Yes, SELECT ALL would make this killer!
This is great but we need to SELECT ALL once the list is filtered by our key word in the search box.
Julian Mora commented
Is there any work in progress to improve the search capabilities on the slicers? Have you ever thought in adding more than one field to the slicer so the search capability of searching things around can be more powerful. I have seen this feature in QlikView where you can add n number of fields on the search button. Here is the idea: you may want to add something similar to the tooltips where you can drop some extra fields that can be used on the search box of the slicers. The explanation: let´s say that you have several plants in US and their names are just a code, but they are linked to a zip code, city, state or a particular area (East, South East, etc) so not everyone have the capability to memorize the names of these plants by codes but they can remember the city or the area, so they can enter that reference in the search field so Power BI can filter the results based on that criteria...
Steve Ward commented
I was just thinking 'A searchable slicer would be really good'. Checked the Power BI website and here it is. Great stuff. Would be good to merge the slicer functions onto the table visual too.
Needs to emulate the excel search function have search and multi selections
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.
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.
Andrew Dang commented
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.
Koen Verbeeck commented
This is great! Thanks
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.
Daniel Peng commented
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 ?
I am not seeing this, could you provide a bit more detail please? Thank you.
June update look good, mark as Completed.