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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors
Top Kudoed Authors