Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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!!
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
@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"
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
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!!
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!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |