Shapefiles

[egilbert23]

I am not sure if this is the right section of the forum to be asking this, but I am trying to get a Shape Map in PowerBi using shapefiles. I have tried numerous times and watched many videos but cannot seem to figure out how ot upload my shp file (and other files) to powerBi and get them to fully load in the Shape Map. I have also installed the shape map visual to my PowerBi.

I am trying to get a colored shape map of the US cenus data -- so I have the excel data for population (example) and now i want to use the US census tract data as the map for showing a heat map for population in each city/county based of its geoid or code. If anyone has any tips let me know!  

[Anonymous]

Hi @egilbert23 ,

I’d like to acknowledge the valuable input provided by HotChilli . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue

The following link shows how to use the spatial tools QGIS and MapShaper to create and manipulate spatial files and how to visualise them in Power BI using Shape Maps.
How To Create Custom Shape Maps for Power BI — DiscoverEI

Before adding a custom spatial file to the Shape Map visual object in Power BI, we need it to make sure it is formatted correctly. The required format for the shape map is:
File Type: The spatial file needs to be in JSON format.
File Size: It's a good idea to simplify your spatial file first.
Projection: Make sure your spatial file is projected correctly.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[HotChilli]

I always recommend this page to get familiar with shapemap:

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

It's all good stuff and there is a section on custom maps too