Forum Discussion
How to display a text column as a label on Azure Map when plotting by Lat/Long?
- 7 months ago
Thanks for the explanation! That makes perfect sense regarding why it needs a scalar value like an average.
I actually found a very simple workaround for this where you don't even need to manually change the aggregation. It turns out the order in which you drag and drop the fields completely changes how Power BI handles the data.
Here is the exact sequence that worked for me:
- Drop your text field (Facility Name) into the Location bucket first.
- Drop the Latitude field into the Latitude bucket.
- Drop the Longitude field into the Longitude bucket.
By establishing the text category in the Location bucket before introducing the numbers, Power BI accepts the raw coordinates without throwing an error, and the text labels display perfectly next to the dots.
Thanks again for pointing me in the right direction!
Hi!! This is a common limitation of the Azure Maps visual... and unfortunately what you’re trying to do is not fully supported natively today.
The best workaround is use longitude, latitude and Name (put in on your legend field).
Then in the visual:
Format > Category labels > On
Layer > Bubble layer (not heatmap).
Hope that help!!