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