Forum Discussion

AlexDantin's avatar
AlexDantin
Helper I
11 years ago

Map visualization limits and issues

I have an excel spreadsheet that I am testing out the map visualization with. the total dataset is less than 40K lines in 4 columns (Quarter-Year, State, Zip, and Value). When I import the data into ...
KStommel3's avatar
KStommel3
New Member
9 years ago

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's avatar
kcwilsonii
Helper I
9 years ago

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