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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ssusin
Regular Visitor

Missing ZIP Codes in Excel 3D Maps

In Excel 2016 3D maps, certain New York City ZIP codes are missing. Two examples are ZIP codes 10024 and 10014. That is, when I try to get these regions outlined, they appear blank, while most ZIP codes in New York City appear correctly. However, when I change the visualization to something else, such as "bubble", a bubble is plotted in the correct place, so I don't think the problem is with my data. 

 

 

13 REPLIES 13
ncruz
New Member

Good Morning All,

 

I have looked everywhere for a solution and can't seem to find it.  I am trying to use 3d maps and it will not take my data.  The data I have is three columns:  City, State and Zip and when I try to add data to 3d maps it saids that the "data source reference is not valid"  What am I doing wrong?  Thanks in advance for your reply.

 

dh5237
New Member

I'm having a problem with 3D Maps not finding a resolution for a set of several zip codes mainly the problem is with Zip Code with Leading Zero's  in Puerto Rico and the US Virgin Islands.  I 'm currently working on get the Lat and Lon data for my entire data set to hopefully eliminate the problem global . Overall I had a 95% Mapping Confidence for 13,051 unquie zip codes.  Any insights would be appreciated. 

Examples:

00603;00612;00659;00674;00680;00682;00692;00693;00694;00698;00716;00725;00729;00731;00732;00736;00738;00740;00757;00778;00784;00791;00802;00820;00840;00901;00907;00912;00917;00918;00926;00949;00957;00961;00962;00965;00966;00968;00976;00979;00982;00983;00987

 

 

Have you tried to format the zipcodes as text in the excel-sheet? it worked for me 🙂 

Still doesnt fill in the missing zip codes as they were already set to text. There are just some zip codes that dont populate.

Excel 3D Maps also has a problem misplacing zip codes over other zip codes and labeling them wrong.

 

Program has been too "broken" for our business to use. We just can't rely on it, we've already switched to a different map program that works a million times better.

What program are you using? 🙂

Maptitude by Caliper

Thank you 🙂 Looks good! 🙂

v-haibl-msft
Employee
Employee

This should find its way to excel/excel online support. It's not related to PBI.

 

Best Regards,

Herbert

v-qiuyu-msft
Community Support
Community Support

Hi @ssusin,

 

Based on my test, if we set Location based on Zip code, when change visualization as Stacked Column, ZIP codes 10024 and 10014 can also display in Excel 3D maps . See:

 

q1.PNGq2.PNG

 

In your scenario, how did you specify the Location? You can download attached Excel to have a look. If issue persists, would you please share your Excel file for our analysis?

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Qiuyun,

 

Thanks for getting back to me.

 

I opened your example (zip codes.xlsx), and confirmed that I can see a column on the map for ZIP code 10024. However, when I click on "change the visualization to region", all the ZIP codes are shaded in except for 10024. This is the problem I am having too.

 

I've put together an example that shows that the problem occurs in less artificial circumstances, but I don't seem to be able to upload attachments to this forum.  In any event, your example illustrates the problem pretty well.

Hi @ssusin,

 

I already reported this issue internally, will keep you updated once get any feedback.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Have there been any updates to this issue?  Not sure how to explain to my folks that some zip codes in Georgia just won't show up in their maps!

 

Im having the same issue but with zip codes right here in the USA. Specifically 22556 Stafford Virgina, 53142 Kenosha and 53403 Racine Wisconsin. I want to see the Visualization by Region. When I have this set by County the whole area is colored, but as you can see from the picture, when it goes to zip codes I have holes in my map. I've tried deleteing and re-adding the data, doesnt help. HELP has this been fixed yet?!?!

 

Stafford County in VAStafford County in VA22556 missing zip code22556 missing zip code

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors