cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Adiuser
Regular Visitor

Search text within drop down filter

Hi All , We have a slicer for a report on country/cities . We want to be able to give user the option to enter few letters of the city/country filter so they can quickly locate it rather than scrolling all the way down for a slicer with 30-40 values. Ex- If user wants to locate city - 'Zurich' he will have to scroll down a long list to check on the city. Rather on typing 'zu' in the same filter zurich should filter out . Is this possible? I checked on 'text Filter' but that will not give a dropdown list , I want both - A search within a drop down list as the list is too long. Thanks In Advance.
1 ACCEPTED SOLUTION
alexei7
Continued Contributor
Continued Contributor

Hi Adiuser,

 

Yes, you can do this within the Slicer visual.

 

If you click the elipsis (three dots) in the top-right corner, you'll get a menu to search and you can do exactly what you're asking.

 

Slicer.PNG

 

Thanks

Alex

View solution in original post

4 REPLIES 4
alexei7
Continued Contributor
Continued Contributor

Hi Adiuser,

 

Yes, you can do this within the Slicer visual.

 

If you click the elipsis (three dots) in the top-right corner, you'll get a menu to search and you can do exactly what you're asking.

 

Slicer.PNG

 

Thanks

Alex

View solution in original post

Hi 

can this be done for numeric value filters as

123456

645355

543423

989877

 

I tried applying the same method and it does not show up. 

 

Thanks in advance

Do you know if it is possible to change the background color of the search?

@alexei7 @Adiuser 

Awesome , It works!! Thank you .

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!