Map not rendering addresses

[mossshvlw]

I have a column I've created that includes a city, state, zip (as a text column):

There are blank fields. 

Now, when I try to map it using the "map" visualization:

Nothing is mapped.  Can anyone tell me what's going on?  thanks in advance.

[v-jingzhang]

Hi @mossshvlw 

Try @parry2k 's suggestion to change the column's data category to Address or other geographic options so that Power BI does not need to guess whether it should treat this column as address. Also, you don't need to include "address" in the column name.

Regards,
Community Support Team _ Jing Zhang

[parry2k]

@mossshvlw you should still the data category for your column, check previous replies with the links,

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

and best practice.

[parry2k · Accepted solution]

@mossshvlw here is where you set data category

Data categorization in Power BI Desktop - Power BI | Microsoft Docs

[parry2k]

@mossshvlw did you change the category of your column to address or place?

Read this post for best practices.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[mossshvlw]

Amazingly, when I renamed the column to have "address" in the title, even though it is not an address but a city, it worked.  Very intuitive, power bi...🙄