Forum Discussion

ecoale's avatar
ecoale
Icon for Helper I rankHelper I
5 years ago
Solved

Shape maps for Italy... HELP :O

Hi to everyone! I am getting crazy... please I need help... 😞

I have to put in a Power BI desktop report a shap map for Italy provinces... I got a precious shapefile from this link (first reply to the post, zip "Shapes"): https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=2057&MessageKey=bda8bbcf-cba9-4151-8c25-7f281ea4383d&CommunityKey=c2514ce0-22a2-4fe1-bacc-3919141bdc16&tab=digestviewer  And it works, also in Power BI desktop (IMAGE 1)!

But unfortunately it is old... in fact in Italy the organization in provinces is now changed a little (above all Sardegna).

Fortunately I found this shapefile from ISTAT (Italien Istitute for Statistcs), updated to 2021: https://www.istat.it/it/archivio/222527

So I downloaded the last one, I uploaded it (all the files inside) on mapshaper: https://mapshaper.org/ and in effect I see the new Italy provinces.

At this point I exported the topojson file and I uploaded it in Power BI desktop as new personalized shape map, but it does not work in mercator format (IMAGE 3):

and it works but very very small in equirectangular format (IMAGE 4):

 

Please could you help me?????? 😕 I am getting crazy...

Thanks a lot for your time

Alessio

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hiecoale , 

    When you upload your TopoJSON or GeoJSON to Power BI Desktop, it needs to be in the WGS-84 coordinate system.

    To make sure your map uses WGS-84, after you drop the file into Mapshaper, open the console in Mapshaper (either by clicking on "Console" in the top right corner or by pressing your spacebar).

     

     

     

    Then type " proj wgs84" in the console and press Enter.

     

     

     

    Finally, follow your previous steps to add the .JSON file to the custom map in Power BI Desktop as normal.

    You will get the map below, it works fine in either projection.

     

     

     

    Here is an article for your reference: How to upload your own map

     

    Hope it helps.

     

    Best Regards,

    Caitlyn Yan

     

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hiecoale , 

    When you upload your TopoJSON or GeoJSON to Power BI Desktop, it needs to be in the WGS-84 coordinate system.

    To make sure your map uses WGS-84, after you drop the file into Mapshaper, open the console in Mapshaper (either by clicking on "Console" in the top right corner or by pressing your spacebar).

     

     

     

    Then type " proj wgs84" in the console and press Enter.

     

     

     

    Finally, follow your previous steps to add the .JSON file to the custom map in Power BI Desktop as normal.

    You will get the map below, it works fine in either projection.

     

     

     

    Here is an article for your reference: How to upload your own map

     

    Hope it helps.

     

    Best Regards,

    Caitlyn Yan

     

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    Do you have empty source data somewhere that forces the inclusion of the Equator/Main Meridian spot?  You should be able to use Mapshaper to crop your data, or you can parse it manually and exclude all data points that are outside of Italy's Lat and Lon ranges.