filled map location sees US states column as country

[etescher]

Brand new to filled map visual (appology in advance).  I place two character STATES column in LOCATION field in Power BI Service, and Map recognizes as Countries.  I have tried full state name and changing column names.  For example, CA is seen as Canada NOT California.  I used column headers as TERRITORY and US STATES.  Same results.

Thank you!!!!

[Anonymous]

You can also go into the map settings and change Location to "one County", US. 

[Anonymous · Accepted solution]

Try adding the Suffix ",US" to CA so, "CA,US"

@etescher you can achieve this by going into the Data tab, clicking New column the pasting in the following, ensuring you change "Table Name and Column Name to reflect your own dataset. 

NewColumn = CONCATENATE('Table Name'[Column Name],",US")

[Rej]

Hi, I was still having a problem with "AZ,US" showing up in East Asia.  I changed ",US" to ",USA" and now it works fine for all states including Arizona

[etescher]

Hi Karlos,

Thanks for the attempt.  I loaded field concatenated.  Behavior was that entire US highlighted as one object.  If I unselected one state, from filter, none of map highlighted.  I wonder if there is something unique to POWER BI SERVICE.  Options you chose like layers were not available to me.  

Thanks for trying,

Eric

[Anonymous]

Upload a copy of your PBIX file and I'll take a look . 

I just noticed that my screenshot above is incorrect, as it had Boundaries selected under "represent Locations as", you need to ensure this is "Points" 

[etescher]

I am adding image which I should have done earlier

[etescher]

Sadly, I am not able to take advantage of your expertise because I am using Power BI Service (Cloud).  It appears NOT capable of downloading PBIX file.

Thanks!

Eric

[etescher]

Note 3 fields with GLOBES.  It appears Power BI sees data as it should and recognizes location.  Fullstate is the full text name for each state.  I keep trying to offer every clue I think of.

[Anonymous]

See if you can reverse what I've done. Click on the link below to download the PBIX file, then upload it to the service. 

https://1drv.ms/u/s!AnIEh6WhI4JogrAUcQ6grqniMlMwoQ?e=AuqXcy