Mapping Singapore as a state

[Flammie]

Hello all! I am mapping my data by state. I have all of my locations working fine (Even Puerto Rico), except Singapore. I have pasted my code below on how I got all the states to work. For Singapore, I have tried SGP, SP, SG, Sing, the longitute and latitue numbers, Singapore, 819643, .sg, sing., and Republic of Singapore. Everything else is plotting as a state and I need Singapore too as well. It doesn't have to be the EXACT center or Singapore. I just need the dot in there somewhere. Does anyone have any ideas?

Entity Location = SWITCH(Complaints[Entity], "Batesville", "indiana", "Monterrey", "Nuevo León", "Pluvigner", " Bretagne", "Lulea", "Lulea", "Singapore", "SGP", "Michigan", "Michigan", "Acton", "massachusetts", "Las Piedras", "San Juan, Puerto Rico")

[v-piga-msft]

Hi @Flammie ,

By my research and tests, I'm afraid that the "SGP" is not a state name for Singapore.

You should find a State/Province name in Singapore.

Entity Location =
SWITCH (
    'Table2'[Entity],
    "Batesville", "indiana",
    "Monterrey", "Nuevo León",
    "Pluvigner", " Bretagne",
    "Lulea", "Lulea",
    "Singapore", "Potong Pasir",
    "Michigan", "Michigan",
    "Acton", "massachusetts",
    "Las Piedras", "San Juan,Puerto Rico"
)

Please refer to my test restsult.

Best  Regards,

Cherry

[Flammie]

---

@v-piga-msft wrote:

Hi @Flammie ,

By my research and tests, I'm afraid that the "SGP" is not a state name for Singapore.

You should find a State/Province name in Singapore.

Entity Location =
SWITCH (
    'Table2'[Entity],
    "Batesville", "indiana",
    "Monterrey", "Nuevo León",
    "Pluvigner", " Bretagne",
    "Lulea", "Lulea",
    "Singapore", "Potong Pasir",
    "Michigan", "Michigan",
    "Acton", "massachusetts",
    "Las Piedras", "San Juan,Puerto Rico"
)

Please refer to my test restsult.

Best  Regards,

Cherry

---

What is your data catagorized as? I have mine set to "State or Province"

[v-piga-msft]

Hi @Flammie ,

I set the Entity Location column to be "Country" data categeory.

You also could have a  reference of my attachement.

Best Regards,

Cherry

[Flammie · Accepted solution]

I needed smaller than a country. State didn't work so I used LAT and LONG which worked really well. I recommend that for anyone needing a smaller area for data analysis. But, yes, your solution works really well for country. Thanks!!

[Flammie]

That did not work for me but I am going to try other places in Singapore and see if I can find one that will work. I'll update if I do. Thanks!