Forum Discussion
Helper IMap visualization limits and issues
Memorable MemberMapping can be a little flaky if you let it up to Bing to geocode everything. What you may want to do is to add a column to your dataset that will help Bing do a better job geocoding.
For example, if you have a column for a city and another column for a state, I would create a CityState column that would take Chicago and IL and turn it into “Chicago, IL”. You can enhance this further if geocoding still is not perfect by adding IF logic and turning PR into Puerto Rico. So if you have San Juan as a city and PR as a state, I would create a column that said “San Juan, Puerto Rico” and let service geocode that. My guess is that it would do a much better job.
This worked, thank you. I concatinated the city, state, and zip in a new column of my source spreadsheet. Then I saved it and "refreshed" the data in PowerBI. Once updated, I went to the "Data" menu on the left (the table looking icon) and highlighted the new column I made. Under the Modeling tab, I changed the "Data Category" to "Place".
Bingo....all US cities.
Now if I could only figure out how to add just the city names (not the concatinated city/state/zip) and the count for each city to the map visualization, I'd be golden!
kcwilsonii>>Now if I could only figure out how to add just the city names (not the concatinated city/state/zip) and the count for each city to >>the map visualization, I'd be golden!
I would look at building a custom hierarchy. Might be another way to map this properly and still be able to get a city count
- AlexDantin
Seems clunky to have to add yet another column to my data when the tool is supposed to understand and use filters for geo-coding intelligently.
If the new column isn't stored in the DW, then every time end-users who are supposed to use the tool will run into the same problems.
- andre
Well, city names are not unique so if you city name is Paris, i would not expect the mapping engine to know which Paris it is. So adding a state to a city name helps with that.
When drill down is back, one thing I would expect to improve would be for the map to remember what state I drilled into so that it can only show the cities in that state without me having to add the state to the city name. Other than that, I think having a field in the model that uniquely identifies a location is probably the safest way to go about it.
What I did is concatenated Address, City, State, Zip and it plots points pretty well. This is good for customer level but you will run into value limits. Question is, what is the official limit?
