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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Using .shp files in Power BI to create maps

Hi,

 

I have an SHP file that I am able to view using QGIS. I need to use this file to create a shape map in PowerBI.

I have converted the file to .geojson and then to TopoJson as suggested by many threads. I am unable to move forward from this point. 

 

This is what I see when I upload the TopoJSON fileThis is what I see when I upload the TopoJSON file

After I convert it to a table.After I convert it to a table.

I am stuck at this point and don't know how to expand this into a table contianing all my information and being able to plot the shape map. 

 

I have tried this solution but it doesn't seem to work for me. Not sure if I am doing something wrong or if it is the wrong approach entirely for my case.

 

Any help is highly appreciated! 

TIA

3 REPLIES 3
v-yingjl
Community Support
Community Support

Hi @Anonymous ,

To create shape maps by using your custom topojson files, you can try the following steps without uploading it to Power Query Editors:

  1. Using the latest version power bi desktop,( https://www.microsoft.com/en-us/download/details.aspx?id=45331) ,enable Shape map features (Files > Options and settings > Options > Preview features > Shape map visual).options.png
  2. When you create a shape map, in Format menu, under Shape options, select +Add map and choose your custom .json file.shape map.png

For further information about shape map, you can refer the following Microsoft document that can also help you:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

 

Best Regards,

Yingjie Li

 

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

HI, Sorry to bring this up again, but I have a similiar situation. I have done the above steps using the custom maps, however the Map contains Alaska and Hawaii.  In R, it looks like a filter can be applied to the shape map.  Is that possible in Power BI?

Hi @Anonymous ,

 

maybe this helps.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.