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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Kudoed Authors