zip code appears outside of US on PBI

[bbbbi01]

Hi! I'm trying to create a map hat shows different zip codes with their corresponding store numbers. I have a sheet with 2 columns: one listing the zip codes and the other listing the store numbers. However, when I used the Map function, some zip codes appear outside the US, though all of them should be US zip codes. I already set the data type to "Text". 

Also, I tried to use the shape map or filled map, nothing appears. Does anyone have any insights on how to fix this?

Thank you!

[DataNinja777]

Hi @bbbbi01 ,

I encountered a similar issue a few months ago, which I resolved by creating a country field in the location table and using it as the legend in the map visual.

Best regards,

[bbbbi01]

Thanks for your reply. May I ask if you just created a column listing country and then put it into legend?

[DataNinja777 · Accepted solution]

Hi @bbbbi01 ,

Yes, that is correct. Adding the country column to the legend will resolve the issue if it arises from ambiguous locations caused by using only the zip code.

Best regards,