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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Bryan_Schmidt
Helper I
Helper I

How to create census tract maps in Power BI

Is it possible to create census tract maps in Power BI? If so, can someone please advise the steps to take? I've downloaded the shapefiles from the Census Bureau. Power BI doesn't allow importing of shapefiles but does support those in JSON format. I have converted a few of these to JSON format and imported them to Power BI. I have tried using the shape map visual in Power BI to display the results but regardless of what I enter in the Location or Legend box, nothing appears on the map. I need to know the following:

1. What shapefiles are needed to display census tracts and their related numbers? There are multiple shapefiles with extensions of shp, shx, dbf, and others. For now I just need to show census tract boundaries and tract numbers.

2. After the JSON file has been imported to Power BI, what steps are needed to display the tract boundaries and numbers?

 

Any suggestions would be appreciated.

2 REPLIES 2

Thank you for replying to my question. I looked at all the links you provided and, unfortunately, none of them answer my questions. I'm guessing I don't have the correct shapefiles converted to JSON format. There are 125 shapefiles for Polk County, Oregon. Which of these needs to be converted to JSON format? If it is just those with shx, shp, and dbf extensions, there are multiples of these so I need to know which ones. It's interesting that census tract is not an option that appears in Data Category. Does this mean Power BI is not able to recognize census tract geography? 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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