Azure Map Visual

[DJ-P]

can i add pins to azure maps in power bi? currently it shows all customer locations as bubbles on a map and i want to add service locations as a pin to see how far customers live from service location

[DJ-P]

Currently i have a workaround in place where i added service locations into customer location table and coloured them in a different colour to customer location.

[Poojara_D12]

Hi @DJ-P 

Yes, you can add pins to Azure Maps in Power BI, but the way to do it is by layering different data categories. The Azure Maps visual lets you plot data points using latitude and longitude, and you can differentiate customers and service locations by assigning them different categories, symbols, or colors. For example, you can keep customer locations as bubbles sized by volume or count, and then add your service locations as a separate dataset with a distinct category that uses a fixed symbol, such as a pin or custom marker. The legend and formatting options in the Azure Maps visual allow you to style these differently so they stand out from customer points. This way, you’ll have both sets of locations on the same map—customers as bubbles and service locations as pins—so you can visually assess the distance between where customers live and where your service points are located. If you need actual distance calculations, you can also use measures or Azure Maps’ reference layer features to compute and display distance.

[DJ-P]

Not sure exactly how would i do this without creating a relationship between customer and service locations? How do i layer different data categories?

[Poojara_D12]

Hi @DJ-P 

Yes, you can add service locations as pins in Azure Maps in Power BI, but it requires thinking of them as a separate layer of geographic data rather than merging them into your customer table. Right now, your workaround of adding them into the same table and differentiating by color works, but it mixes two different entities (customers and service centers), which makes maintenance and analysis harder.

The better way is to keep two datasets (customers and service locations) and use them as different layers in your map. In Power BI’s Azure Maps visual, you can add multiple layers like bubbles, reference layers, or symbol layers. For your scenario:

• Customer locations → Keep them in one dataset and display them as bubbles (with size representing customer density, spend, or just uniform bubbles).

• Service locations → Add them as another dataset and use the Symbol Layer (pins, markers, or custom icons). This way, they show up as distinct points (like pins) overlaid on the same map.

You don’t need a relationship between the two tables unless you want to filter customers by service center. For example, if you want to calculate the nearest service center for each customer, you’d need DAX logic or a calculated column (using latitude/longitude distance formulas). But if your goal is just visual layering (customers vs. service centers), you can directly layer them on the same Azure Map visual without creating relationships.

Here’s how you could approach it:

1. Load your Customer and Service Location tables separately.

2. Add an Azure Maps visual to your report.

3. In the Layer pane of Azure Maps, add one layer for Customers (Bubble Layer) and another for Service Locations (Symbol Layer with pin icon).

4. Customize formatting (color, icon, size) so service centers are clearly visible as pins while customers remain bubbles.

[DJ-P]

I did step 1 and 2 as listed by you. however, i dont get the option for adding different layers.

[Poojara_D12 · Accepted solution]

In the Azure Maps visual in Power BI, you don’t have the ability to add multiple dynamic layers from different tables directly, which is why you only see options like Bubble Layer or Filled Map in the settings. That limitation is the reason you had to combine your customer and service location data into one table and distinguish them by color. If you want to keep them separate, one workaround is to use a Reference Layer, where you prepare your service locations as a GeoJSON file and overlay them as pins on the map while still showing your customer data as bubbles. However, these reference pins will be static and won’t behave like fully interactive data points. If your requirement is to have multiple interactive layers (for example, customers as one layer and service centers as another, both dynamic), then Power BI’s Azure Maps visual cannot do this, and you would need to either continue with your combined table approach or use the ArcGIS Maps for Power BI visual, which does support multiple layers.

[DJ-P]

Got it, thank you for your assistance

[danextian]

Hi @DJ-P 

I don't think that is currently supported. Your option is to load the coordinates of these service locations in the model and use the haversine formula to compute the distance between the two  points. 

Please see the attached pbix. 

[DJ-P]

Thank you, much appreciated. i will try this out.