Azure Map VIsual - Multiple Bubbles in Same Location

Hi meiwah,

To display multiple bubbles in the same location using the Azure Map visual in Power BI, you'll need to follow these steps:

Steps to Create Multiple Bubbles in Azure Maps

1. Prepare Your Data:

   • Ensure your dataset includes the relevant fields for location, iPhone sales, and Android sales.

   • You might structure your data as follows:

     Store Location	iPhone Sales	Android sales
     Store - A1	$500	$900
     Store - B1	$1000	$300

2. Unpivot Your Data:

   • To show both iPhone and Android sales as separate bubbles, unpivot your data:
     • Go to the "Transform Data" option in Power Query.
     • Select the columns for iPhone Sales and Android sales, right-click, and choose "Unpivot Columns".
     • This will create a new column for Sales Type (iPhone or Android) and a Value Column representing the sales numbers.

3. Add Azure Map Visual:

   • Go back to your report and add the Azure Maps visual to your page.

4. Configure the Visual:

   • Drag the location field to the Location well in the Azure Map.
   • Drag the Sales Type to the Legend well to differentiate between iPhone and Android.
   • Drag the Value to the Size well to adjust bubble sizes based on sales numbers.

5. Customize the Bubbles:

   • In the visual settings, you can customize the colors for each category:
     • Click on the Azure Map visual, go to the "Format" pane, and find the "Data colors" section.
     • Set the colors for iPhone sales to red and Android sales to blue.

6. Adjust Map Settings:

   • You can also adjust the zoom level and map styles to improve visibility if bubbles overlap.

Finalizing Your Report

• After setting everything up, you should see two bubbles at the same location representing iPhone and Android sales, colored accordingly. Adjust the sizes if necessary to make sure both bubbles are clearly visible.

Troubleshooting Tips

• If you still don’t see multiple bubbles, double-check the unpivoting process to ensure both sales types are correctly represented.
• Make sure your data has sales values greater than zero for both types to display both bubbles.

This setup will allow you to effectively visualize the sales of iPhone and Android phones in the same location on your Azure Map.

If I have resolved your question, please consider marking my post as a solution🎉. Thank you!