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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
KatNix
Frequent Visitor

Azure Map Showing County Incorrectly

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: 

MissingSteeleCountyMapLatLong.png

MissingSteeleCountyMapHierarchy.png

  

SteeleMantuaItalyMap.png

7 REPLIES 7
KatNix
Frequent Visitor

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 nowSteeleCountyMNSmallerSubset.png. 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.

KatNix
Frequent Visitor

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

KatNix_0-1724903570456.png

 

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.

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.

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

lbendlin
Super User
Super User

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

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.  ThanksCustomShapeMapMinnesota.png

 

 (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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors