Using Address Location

[Maureen]

What is the best way to display a city on a bubble map when the best location information that you have is city and state?    I have designated my city column as "city" and state as "state" for data category.  I have also tried building a new column with city, state and designating it as address location which the bubble map does not seem to recognize - it maps nothing with this new field.  If I put both city and state in the location fields, it will map the state but not the city.  If I build a hierarchy with city within state, it will correctly display the state but if I drill-down to city, the city may not land in the state (for example, St. Petersburg, FL shows up in Russia instead of Florida).  How can I make the bubble map see the city and the state together . . .

[Maureen]

Of course!   Thanks!

[amitchandak]

@Maureen ,

Refer if these can help

https://community.powerbi.com/t5/Desktop/Full-addresses-not-plotting-on-map/td-p/221834

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

[Greg_Deckler · Accepted solution]

Believe it or not, use Place for your concatenated city, state column.