topic Re: Azure Map Showing County Incorrectly in Custom Visuals Development Discussion

Azure Map Showing County Incorrectly

KatNix — Wed, 28 Aug 2024 13:38:43 GMT

Hello, I am having trouble showing Steele county MN correctly in an Azure map. It keeps showing Steele, Mantua in Italy (the yellow area on the screenshot). I have tried using a hierarchy of country(USA)/state(MN)/county in the Location. I have also tried using the latitude and longitude, but then Lake county doesn't show up either. Nothing seems to work. When I tried using a shape map, I could not get the subset of counties that I need. When I tried using the filled map, I can't get the counties to show alone without the road map features. I'd appreciate any help on this. Here are the screenshots. Steele county is the white area on the blue maps:

Re: Azure Map Showing County Incorrectly

lbendlin — Wed, 28 Aug 2024 21:23:30 GMT

You don't happen to have your own topojson file with the county shapes, no?

Re: Azure Map Showing County Incorrectly

KatNix — Thu, 29 Aug 2024 03:56:01 GMT

No I don't. I tried using github_albersusa.json with the shape map.

It gave me all the counties, but I'm only trying to map certain counties in MN and SD. I was able to add my subset to the legend for the Azure map successfully, but when I added the same legend to the shape map, I got everything instead of just the subset. Where would I reference the json file in an Azure map? Or should I focus on getting the county subset groupings in the shape map? Thanks for your help.

Re: Azure Map Showing County Incorrectly

lbendlin — Thu, 29 Aug 2024 11:20:49 GMT

You could load the topojson file into an editor and remove the shapes you are not interested in. Or keep them unfilled based on your data.

Re: Azure Map Showing County Incorrectly

KatNix — Fri, 30 Aug 2024 03:26:05 GMT

Ok so it sounds like working with the shape map may be the better option. I will try this tomorrow. Thanks.

Re: Azure Map Showing County Incorrectly

KatNix — Mon, 09 Sep 2024 18:07:29 GMT

Hello there,

Your suggestions partially worked. I found a topojson file for Minnesota and South Dakota online at https://gist.github.com/ So instead of trying to edit the file I had for the entire US, I eliminated the counties that I didn't need. I was able to create my custom groups of counties. However, I still have several issues: (1) I would need to figure out how to combine topojson files for multiple states because the custom county groupings are not limited to one state; (2) I had to use conditional formatting to get the colors for the different groups. When I used the Azure mp, all I had to do was put the custom group in the legend; (3) This version of the shape map does not give options to add the county name.

You were correct in suggesting that I needed to use a topojson file when trying to do this with a shape map. Thanks

Re: Azure Map Showing County Incorrectly

lbendlin — Mon, 09 Sep 2024 18:29:45 GMT

(1) I would need to figure out how to combine topojson files for multiple states because the custom county groupings are not limited to one state

Your favorite shape editor should have the ability to load and overlay multiple files. (Mapshaper.org etc)

(2) I had to use conditional formatting to get the colors for the different groups.

Make sure not to drop the shape attributes when exporting.

Re: Azure Map Showing County Incorrectly

KatNix — Mon, 16 Sep 2024 18:11:41 GMT

I have given up on the shape map because it will take too much manual work and I can't get the county labels to show up. I tried the Azure map with a subset of the counties that I wanted to map using the latitude and longitue. Looks like the missing Steele county shows up now. I might add in groups of counties to see if they will all show up. I would hate to think there is a limit on what will show up and I'm only trying to map 95 counties in 2 states.

Re: Azure Map Showing County Incorrectly

Mbrewing12345 — Thu, 07 Aug 2025 18:23:35 GMT

I added "County" to the county name and it seemed to fix the issue. "Steele County" instead of "Steele". There are also some other examples this is needed. Roanoke City vs Roanoke County in VA. Those make some sense. Power BI must be getting hung up on duplicate names.