Forum Discussion

Chamitha's avatar
Chamitha
Regular Visitor
7 months ago
Solved

How to display a text column as a label on Azure Map when plotting by Lat/Long?

Hi everyone, I am using the latest version of Power BI Desktop. I have a data table with 3 columns: Facility_Name Latitude Longitude   I want to do something very simple: plot a dot at ...
  • Chamitha's avatar
    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:

    1. Drop your text field (Facility Name) into the Location bucket first.
    2. Drop the Latitude field into the Latitude bucket.
    3. 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!