Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

View My Drafts

Back to discussions
Expand all | Collapse all

Zip Code/Post Code Map

  • 1.  Zip Code/Post Code Map

    Gold Contributor
    Posted Jul 15, 2019 01:00 AM
    I'm wondering if anyone has successfully created a zipcode/postcode map in Power BI. My goal is to have a map similar to below (from Sydney Australia) with data that would be coming from a very basic data set with 5 columns of data (Country, State, City, Post/Zipcode, $$ sales amount). Is there a preferred add-on for this?

    I've tried many attempts but no luck so far.




    ------------------------------
    Daniel Demers
    Chief Digital Information Officer
    Dan
    61423566444
    ------------------------------


  • 2.  RE: Zip Code/Post Code Map

    Top Contributor
    Posted Jul 15, 2019 09:36 AM
    You have tried the ArcGIS maps?

    https://www.esri.com/en-us/arcgis/products/arcgis-maps-for-power-bi/overview


    ------------------------------
    William Rodriguez
    Business Analyst | MCSA: BI Reporting
    ------------------------------

    Original Message


  • 3.  RE: Zip Code/Post Code Map

    Bronze Contributor
    Posted Jul 16, 2019 10:48 AM
    Daniel,
    I used the ESRI map visual in Power BI to create this simple population by Zip code map. The two columns used are to the right.

    Tim
    ​

    ------------------------------
    Tim Dyeson
    Performance Measurement Manager
    ------------------------------

    Original Message


  • 4.  RE: Zip Code/Post Code Map

    Posted Jul 16, 2019 01:40 PM
    I just did this last week! It was quite the effort to get it working, but eventually it worked.

    There's an option in Power BI Options called Preview Features. I selected the "Shape Map visual" and then was able to build my map from there. It requires a zip code JSON file, which I was able to find on a public repository on Github.

    Good luck! I'm happy to answer any questions if you have them.

    ------------------------------
    Alissa McBain
    Business Intelligence Analyst
    9163374590
    ------------------------------

    Original Message


  • 5.  RE: Zip Code/Post Code Map

    Top Contributor
    Posted Jul 17, 2019 09:13 AM
    @Alissa McBain
    I was just looking at that shape map. Very interesting visual. Do you have the link to the zip code json file you used? I tried a couple different ones but it didn't seem to work.​

    ------------------------------
    Sam Duval
    46123
    Indianapolis
    3175245195
    ------------------------------

    Original Message


  • 6.  RE: Zip Code/Post Code Map

    Posted Jul 17, 2019 01:42 PM

    @Sam Duval

    It was my understanding that the files had to be Topo JSON files, and I found some US data here:
    https://github.com/storiesofsolidarity/us-data/tree/gh-pages/geography

    There's also some international data here:
    https://github.com/deldersveld/topojson

    There's some interesting information on TopoJSON here:
    https://github.com/jgoodall/us-maps

    and here:
    https://github.com/topojson/us-atlas

    This was definitely the hardest part of my project, finding the json file that I needed!

    Good luck!



    ------------------------------
    Alissa McBain
    Business Intelligence Analyst
    ------------------------------

    Original Message


  • 7.  RE: Zip Code/Post Code Map

    Top Contributor
    Posted Aug 02, 2019 02:49 PM
    @Alissa McBain Thanks for the links, works perfectly for mapping. Now only if the PBI devleopers would add the ability to add data labels to the map...​

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Indianapolis
    ------------------------------

    Original Message


  • 8.  RE: Zip Code/Post Code Map

    Posted Jan 29, 2020 05:06 PM
    @Alissa McBain

    Thanks for posting these links.  How did you connect the JSON file in Power BI ​in order to utilize these?
    Thanks

    ------------------------------
    Robert Rund
    ------------------------------

    Original Message


  • 9.  RE: Zip Code/Post Code Map

    Top Contributor
    Posted Jan 29, 2020 06:28 PM
    @Robert Rund if you use the shape map visual, under settings, there is a section for new shape or map. It's the same section that lets you change the built in maps

    ------------------------------
    Sam Duval
    Data Quality Analyst
    Indianapolis
    ------------------------------

    Original Message


  • 10.  RE: Zip Code/Post Code Map

    Posted Jan 29, 2020 06:44 PM
    @Sam Duval
    Thanks for the response, I see that now.  I still can't figure out how to get that file imported into PBI though. Am I missing how to download the file or is there a way to import the JSON?  I'm new to PBI so I'm not super familiar with JSON.​
    Appreciate the help.

    ------------------------------
    Robert Rund
    ------------------------------

    Original Message


  • 11.  RE: Zip Code/Post Code Map

    Top Contributor
    Posted Jan 29, 2020 08:14 PM
    You have to first make sure you have the actual topo JSON file downloaded, if you downloaded a zip you'll have to extract it. then from there under options/settings (the little gear) under shape there is an option to add new map


    ------------------------------
    Sam Duval
    Data Quality Analyst
    Indianapolis
    ------------------------------

    Original Message


  • 12.  RE: Zip Code/Post Code Map

    Posted Mar 15, 2020 09:29 PM
      |   view attached
    Alissa,

    Are the files you used (that you reference in your first link) actual TopoJSON files, or did you have to convert them to TopoJSON? I'm trying to do something for Tennessee so I download the following file (by clicking the Raw button then choosing Save As...not sure if that's the right way but I'm not a master Github user).

    https://github.com/storiesofsolidarity/us-data/blob/gh-pages/geography/zipcodes/Tennessee.geo.json

    When I did this and then selected this file as the custom map in Power BI (with my numeric variable in the Color Saturation box), nothing rendered. It looks like it accepted the TopoJSON file as it's allowing me to change the projection, but what I particularly noticed is that, when I click on 'View map keys...', nothing pops up, which indicates to me that something's not connecting correctly. Any suggestions? I've uploaded the .pbix file I'm working on (which contains a functioning map using the ArcGIS map, but I don't like it).

    ------------------------------
    Eric Stephens
    615-341-4465
    ------------------------------

    Attachment(s)

    pbix
    Zip Code Map Test.pbix   54 KB 1 version
    Original Message


  • 13.  RE: Zip Code/Post Code Map

    Posted Nov 26, 2020 05:09 AM

    Hi ,

    Thanks for sharing link. Actually i am using visual Drilldown Choropeth visual, where the requirement is for drill down in countries and 3digit zip code , for 3digit zip  I i need the link of topojson ​file. Please can anybody help



    ------------------------------
    Priya Gupta
    ------------------------------

    Original Message


  • 14.  RE: Zip Code/Post Code Map

    Posted May 02, 2022 04:16 PM
    Thanks for sharing this data sources.
    Actually, I need a json file for MapShape by US Zip Codes, and tried some sources but could not find what I need.
    Could you let me know where to get it?

    Thanks!

    ------------------------------
    Yunhee Bae
    Data Analyst
    ------------------------------

    Original Message


  • 15.  RE: Zip Code/Post Code Map

    Posted May 03, 2022 12:06 PM
    Edited by Yunhee Bae May 03, 2022 12:21 PM
    I think I have gotten the solution from the MS website where the solution for me is:
    I have found that Power BI supports TopoJson format for Shape maps.
    You may get the GeoJson file for US State Zip Code here and convert it to TopoJson format on the MapShaper

    Thanks!

    ------------------------------
    Yunhee Bae
    Data Analyst
    ------------------------------

    Original Message


  • 16.  RE: Zip Code/Post Code Map

    Silver Contributor
    Posted Jan 29, 2020 05:28 PM
      |   view attached
    Hi Daniel,

    good luck finding anything Australian related.  I have managed to find a listing from Australia Post with lat and long for each Post Code.  That might be helpful.  The other responses look like they should help with which visual to use.

    ------------------------------
    Neville Howard
    Consultant
    Brisbane
    0732228400
    ------------------------------

    Attachment(s)

    zip
    Australian_Post_Codes_Lat_Lon.zip   292 KB 1 version
    Original Message


  • 17.  RE: Zip Code/Post Code Map

    Gold Contributor
    Posted Jan 30, 2020 07:28 AM
    Hi Daniel,

    I have used all of them - Mapbox is one you should definitely look at as well as ESRI. I would stay away from the Microsoft preview shape map. It is very limited and extremely slow (it can hang up your application). They have done nothing with it.

    ------------------------------
    Dan Quigg
    CEO
    Public Insight
    Hudson OH
    330-656-9201
    ------------------------------

    Original Message