Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

awarriorpoet

Map doesn't resolve PR as Puerto Rico

Submitted by Helper I on ‎03-14-2023 03:57 PM

I have a dataset with addresses that include city/state/country. on my report I am using the Map Visualization using the City and State field. For my Puerto Rico addresses (State = PR) it is showing up in Paraguay.   Bing maps resolves PR correctly.

 

awarriorpoet_0-1678834506763.png

 

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎03-14-2023 06:31 PM

Hi @awarriorpoet 

I tried to restore the scenario you mentioned but failed, can you provide your sample for reference ?

 

Best Regards,
Community Support Team _ Ailsa Tao

awarriorpoet
Helper I
Helper I
‎06-28-2023 07:50 AM

If I spell out the US state it resolves correctly, but with two letter abbreviations, it is hit or miss. 

 

For example, most of the time it will resolve CA as California, sometimes it shows it in Canada. PR might be Puerto Rico, sometimes Paraguay.    The STATE Column is set to text.

 

Table has several hundred thousand rows, it may resolve most of them correctly and some of them seem to randomly pick a COUNTRY with the same abbreviation as a state.  This is a very large table.

 

 

Idea Statuses