Need help with custom shape map json

[rahulcv]

I've created a custom map in QGIS and am trying to use it in power bi.

It has two layers, states and counties, where the counties are the borders of the counties in the US and the states layer refers to the thick state borders.

When i upload it to power bi, it only displays the states map and not the counties map, in other words the states layer is the only one being shown.

I tried to convert them into lines, but the same would repeat.
How do I work around this, or is there another map that I could use which have thickened state borders with the counties in them.

Thank you for your help!!

[Anonymous]

Hi @rahulcv ,

Ensure that your TopoJSON file includes both layers (states and counties). You can use tools like Mapshaper (https://mapshaper.org/) to inspect and edit your TopoJSON file.

For more details, please refer:

Custom Shape Map - Insert City Polygon in State Co... - Microsoft Fabric Community

How to create geographic maps in Power BI using custom shape maps (sqlshack.com)

Creating my own Map Shapefiles for Power BI – SQLServerCentral

Best Regards,

Neeko Tang

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

[rahulcv]

Hello @Anonymous,
Thank you for the helpful links; they were certainly pointing in the right direction. However, I encountered an issue where the solution didn’t fully work as expected in Power BI. It seems, that Power BI might not parse certain JSON file attributes correctly, specifically those related to stroke-width and color in the style tag. These styling attributes appear to be ignored during the rendering process.

Given this, I’m looking for advice on how to achieve differentiated state borders on a U.S. counties map in Power BI. My goal is to make the state borders more prominent compared to the county borders, like the picture below ( which was achieved by placing an image on top of the map, but it wouldn't allow any of the interactivity )

If any of my assumptions or steps are incorrect, please feel free to correct me.

I also followed the steps outlined in the above mentioned article and here’s the output from Mapshaper:

However, the resulting map in Power BI looked like this:

Notice, there are two lines at the hand-drawn arrow, which suggests that the merge was successful and is being rendered by Power BI, but the differentiation in line styling is not visible.

Any insights or suggestions to resolve this would be greatly appreciated.