Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
76 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |