Zip Code Map

[kdixon5490]

In our system we capture the zip code of customers.   Is there a map that when I provide the Zip code it would not just Map to the location but would provide me the state and Country that Zip code resides in?

[Anonymous]

HI @kdixon5490 

Same zip code can be present for multiple countries, So unless you have a master data where it has the country and state, it will not be able to pull up the country. 

[amitchandak]

@kdixon5490 , refer if these can help

https://community.powerbi.com/t5/Desktop/Zip-code-map-on-PBI/td-p/516801

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...

https://doc.arcgis.com/en/maps-for-powerbi/get-started/prepare-your-data.htm

https://powerbi.microsoft.com/en-us/blog/retail-location-analytics-using-power-bi/

[mahoneypat]

You can bring in a zip code table into your model that has County and State columns in it.  There are multiple files out there for download.  Then you can make a hierarchy to be used in your map visual.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Greg_Deckler]

@kdixon5490 - Well, I guess filled map will sort of do this, but not entirely certain what you mean.