Filled map using 3-digit Zip codes blank spaces

[Anonymous]

I created a filled map using 3-digit zip codes. For the most part the map is what I need, but I don't know what to do with the "blank" spaces like in Maine, California and Florida. My guess is that these are areas that don't have assigned zip codes. For completeness, I would like to just fill these spaces with the same surrounding color.

How can I do that?

Thank you for the help.

3-digit zip code filled map

[Anonymous]

I am curious how you got PBi to map 3 digit zip codes, can you quickly go over how you accomplished the above?

[v-kkf-msft]

Hi @Anonymous ，

If the dataset you are using has fields for longitude and latitude, please use them.

Or could you please share your PBIX file? That will help us solve the problem faster.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks#in-the-dataset-tips-to-improve-the-underlying-dataset 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey @v-kkf-msft, the main dataset I have doesn't have longitude and latitude data, but I tried to add it and couldn't make it work. How can I upload the pbix file here? I don't see an option to upload files.

Kind regards

 

[v-kkf-msft]

Hi @Anonymous ,

If your PBIX file contains sensitive data, please delete the sensitive data. Then try to upload it to SharePoint and share the link with me.

Best Regards,
Winniz