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.
Let's say my dataset looks like this
Location Name | Latitude | Longitude |
Apple | 40.34 | -80.1 |
Orange | 45.56 | -72.8 |
Banana | 43.23 | -79.4 |
Apple | 43.50 | -73.45 |
NOTE: Notice how there is a repeated Location Name "Apple".
If I were to use the Latitude and Longitude columns to plot on a map, it would plot normally but without labels.
But if I were to add the Location Name to the "Location Field" so that I can get labels over my datapoints. It would ask me to "Remove Location to display latitude and longitude pairs. Alternatively, you can also keep Location and set the aggregate for Latitude and Longitude to Average".
If I average my longitude and latitude points. While I can enable Category to show my Location Name as labels, the point it plots would become the halfway point between my two "Apple" coordinate pairs, in other words, in the middle of nowhere.
(Notice how I lost a data point, and the point's location is almost the halfway point between the previous two "Apple" points).
Does anyone know how I can plot all four points, with all four Location Names showing as Labels over the datapoints (And no, Legends wouldn't work, as my real dataset has hundreds of points and it would be a nightmare to scroll through)
PS. If this is a limitation of mapping latitude/longitude pairs, I also have access to the address of each location.
Thanks,
Solved! Go to Solution.
Hi @wonge7 ,
Currently, if you want to show name in label, you need to use "Location". Or you could see it in legend. You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Add an Index column in Power Query?
Thanks for your reply,
I have added an Index column to my dataset now, but it doesn't seem to affect the results. Could you possibly elaborate on how I'm supposed to use this Index column?
Hi @wonge7 ,
Currently, if you want to show name in label, you need to use "Location". Or you could see it in legend. You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |