Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filled map using 3-digit Zip codes blank spaces

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

4 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support

    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's avatar
      Anonymous
      Not applicable

      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's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support

        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

         

  • Anonymous's avatar
    Anonymous
    Not applicable

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