Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
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.
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! 🙂
This should find its way to excel/excel online support. It's not related to PBI.
Best Regards,
Herbert
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:
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
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
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?!?!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
104 | |
87 | |
35 | |
35 |
User | Count |
---|---|
152 | |
98 | |
81 | |
61 | |
55 |