County Chloropleth Map Using Mapbox

[hamachekm]

Hi,

I am trying to use Mapbox to host a United States County level map in Power BI.

I have been able to complete the wildfire tutorial successfully and make a partial county level map in Popwer BI. 

I have uploaded a full US County map to mapbox: https://studio.mapbox.com/tilesets/mikehamachek.asdajuhp/#3.4/35.05/-96.68

However, my map in Power BI only displays level 1's State view, and will not display the level 2 Counties.

I believe it is due to linking the unique county ID in the map file with the power bi data file (County_FIPS_Distinct). I have tried many different combinations for the Vector Property Level 2, but no luck. Has anyone else tried to upload a US County map to make a Chloropleth? I cannot use ArcGIS. Thanks - Mike

[jhenscheid1]

Hello, has this been resolved or has anyone found a solution to this?  I am running in to a similar issue.  I went through the wildfires tutorial without any issues, but when I run my data, using the same steps, the counties are not displaying.  Is it possibly due to too much data?  I have loaded all US counties and am wondering if there are too many for the layers option to work properly.  

Thanks

[hamachekm]

I was able to load 3 custom maps through the Mapbox website, where the maps were a hierarchy of 3 levels of regions (the smallest granularity layer was similar to county). Then, I could set up one Mapbox visual in Power BI and have a drill-down to view the 3 different layers of regions.   I don't know why the county map did not work - perhaps it is a shapefile quality issue? But, I was glad to figure out that I could work with custom maps in Mapbox and then use with PowerBI.  The trickiest part was to specify precisely the parameters for the map in PowerBI. But, if you figured out the wildfire tutorial, you should be able to figure out this. I think you may need to find different county shapefile though - you may be able to find some through internet search.  Hope this helps you!

[hamachekm]

Thanks Liang for sharing the github link. We actually are going to use a different map style at this time. 

[V-lianl-msft]

Hi @hamachekm ,

Do you follow this setting?

https://docs.mapbox.com/help/tutorials/power-bi-choropleth-map/#add-a-custom-tileset 

Unfortunately, I don't have permission to create Mapbox account for testing. If can't solve your problem, hope it can help you solve the problem here:https://github.com/mapbox/mapboxgl-powerbi/issues?page=1&q=is%3Aissue+is%3Aopen 

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