Can I use two or more layers in an Azure Map PowerBI visual

[EmilioDelgado]

I have a table that has four columns, Latitude, Longitude, Jobs and Tasks. I am able to add either Jobs or Tasks as size, but I need both of them and to format in different colors, for example, the bubbles of Jobs in blue and the bubbles in Tasks in red. Is this possible? I haven't found anything on this issue.

[v-lgarikapat · Accepted solution]

Hi @EmilioDelgado ,Thanks for reaching out to the Microsoft fabric community forum.

@rohit1991 Thansk for your Prompt response.
@EmilioDelgado 

Yes, you can visualize both Jobs and Tasks with different colours and sizes in a single Azure Map visual in Power BI, but it requires a small transformation of your data first. Here's how you can do it step-by-step:

 Step-by-Step Solution

1. Transform Your Data Using Power Query

Your original table:

Latitude | Longitude | Jobs | Tasks

We need to unpivot the Jobs and Tasks columns so that each becomes a row instead of a column:

Steps:

• Go to Transform Data (Power Query Editor).
• Select both Jobs and Tasks columns.
• Right-click and choose Unpivot Columns.
• Rename the resulting columns:
• Attribute → Type
• Value → Count

Your table will now look like this:

2. Add Azure Maps Visual to Your Report

• Insert an Azure Map visual from the Visualizations pane.
• Drag the following fields into the visual:

• Latitude → Latitude
• Longitude → Longitude
• Size → Count
• Legend → Type

3. Customize the Colors

• Select the Azure Map visual.
• Go to the Format pane → Layers → Bubble layer → Colors.
• Assign your preferred colors:

• Jobs → Blue
• Tasks → Red

 End Result

You will now see two distinct bubbles (one for Jobs, one for Tasks) at each location:

• Color-coded (e.g., Jobs in blue, Tasks in red)
• Sized based on the value of each type

Thanks for reaching out to the Microsoft fabric community forum.

If this post helped resolve your issue, please consider giving it Kudos and marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana

[v-lgarikapat]

Hi @EmilioDelgado ,

If your issue has been resolved, please consider marking the most helpful reply as the accepted solution. This helps other community members who may encounter the same issue to find answers more efficiently.

If you're still facing challenges, feel free to let us know—we’ll be glad to assist you further.

Looking forward to your response.

Best regards,
LakshmiNarayana.

[rohit1991]

Hi @EmilioDelgado 

In the current Azure Maps visual, you can’t show two separate layers (like Jobs and Tasks) with different colors or sizes in the same map it only supports one measure at a time.

As a workaround, you can overlay two Azure Maps visuals (one for Jobs, one for Tasks) using the same coordinates, but it takes extra effort and loses some interactivity. If you need more flexibility, try custom visuals like Icon Map or Mapbox, which support multiple layers and styling. Hopefully future updates to Azure Maps will add this capability.