cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Adiuser Frequent Visitor
Frequent 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

Accepted Solutions
Highlighted
alexei7 Member
Member

Re: Search text within drop down filter

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
Highlighted
alexei7 Member
Member

Re: Search text within drop down filter

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

Adiuser Frequent Visitor
Frequent Visitor

Re: Search text within drop down filter

Awesome , It works!! Thank you .
ignas Member
Member

Re: Search text within drop down filter

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

@alexei7 @Adiuser 

kalyan209 Frequent Visitor
Frequent Visitor

Re: Search text within drop down filter

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

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 200 members 2,195 guests
Please welcome our newest community members: