Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
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.
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.
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.
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. Thanks
(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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
27 | |
11 | |
8 | |
6 | |
6 |