Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ac1767
Regular Visitor

Search option using zip codes

Hi,

I am trying to create a search box that allows user to type in zip code and return top 5 clients in that zip code. It seems I can only search by text and I need to be able to use zip codes. Any help would be greatly appreciated. 

1 ACCEPTED SOLUTION

you seem to be using a custom visual.

View solution in original post

9 REPLIES 9
ac1767
Regular Visitor

Is there another way I can create a search box that someone can type a zip code into and the top 5 clients will populate? 

Use the regular filter pane?

Thank you for responding! I appreciate your assistance. It looks like I had to update my data fields as you mentioned in the begining. Once I changed my settings it started working. I appreciate all your help. 

I am obvisioulsy doing something wrong and am not able to get it to work otherwise I would not be on here asking for help. I understand that the regular filter pane is an option but I do not know how to use it since I am not achieving my results. If someone could please assist me with how I can Create a search box to enter a zip code and have the top five clients return to a table I would greatly appreciate it. I thank any one that is willing to assist me. 

ac1767
Regular Visitor

Is there another way I can create a seach box that a zip code can be entered into and top 5 clients be returned? 

lbendlin
Super User
Super User

Are you saying your ZIP code column is not a text column?

It is a text column but I am not able to search by zip code. It is only letting me search by letters. 

 

ac1767_0-1713800576432.pngac1767_1-1713800618141.png

 

you seem to be using a custom visual.

The custom visual was a success. Thanks again for all your help!

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.