Forum Discussion

bwalker42's avatar
bwalker42
Regular Visitor
1 year ago
Solved

Displaying labels on an Azure Map visual in Power BI

Hello everyone,   I have been trying to solve this for the last several days, without success. I created a map of Illinois with unique addresses as dots on the map (using Azure Map).  I'm using ...
Need Help
Tips and Tricks
  • kushanNa's avatar
    kushanNa
    1 year ago

    hi bwalker42 

     

    I’ve added a transparent button on top of the map visual so that no one can interact with it directly. As I mentioned, there’s a limitation — the map won’t work properly with direct user interaction. Only slicer interaction will work.

    You can see the layers in the dashboard by opening the Selection pane. If you want to check the map settings without moving the visuals, you can select the map visual from the Selection panel.

     

     

kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
1 year ago

Hi bwalker42 

 

You need to change the Latitude and Longitude to average, and then you can add a custom label. However, the catch here is that you will need to use County + another unique identifier to identify the location, since we are using averages.

 

I have created a new calculated column using County and Address.

Column = 'Table'[County] &" : " & 'Table'[Address1]

You can also use County + Code if the addresses are too long, as it should still be unique in all cases.

 

 

  • bwalker42's avatar
    bwalker42
    Regular Visitor
    1 year ago

    Thank you for your response.

     

    I have other versions of this map using average of lat and long with an address count for the label.

     

    For this map, they have to have each address as an individual dot so using average won't work.

     

    Thanks,

    Brett

    • kushanNa's avatar
      kushanNa
      Icon for Super User rankSuper User
      1 year ago

      Hi bwalker42 

       

      Sorry for the misunderstanding regarding your requirement. Yes, it seems like we will not be able to have custom labels on the map instead of data points.

      Maybe for your printing requirements, you can try this temporary workaround and see if it works for you ?

      • Add two layers to the map: one with shape and data, and the other with only county labels as category labels.

      • Use the default style as blank on the top map with counties as category labels.

      Limitations: You will not be able to interact directly with the map, but it should work with slicers.

       

      I have attached the sample pbix file for your reference 

      • bwalker42's avatar
        bwalker42
        Regular Visitor
        1 year ago

        kushanNa,

         

        Thank you very much for your reply and sample pbix file.  I appreciate your time.

         

        I'm a newby to Power BI and got this unexpectedly.

         

        I don't understand where the Azure Map visual is when I click on the map.  All I see is "Format button".  I don't know what a "button" is in this context.

         

        Any additional explanation would be appreciated but I understand if you don't have time, etc.

         

        Thank you, 

        Brett