Feasible? Gradient Map with Features

[evanol1543]

Curious if someone who is smarter than the AI platforms I have employed so far can tell me definitively if this is feasible within Power BI Desktop.

Ask:

- Map of the contiguous 48

- Fill color a gradient based on sales volume

- Bubbles overlaid, these bubbles need to be positioned locationally by zip code

- Bubbles also need to be different colors based on a category

Can I have all of these concurrently? Doesn't seem like a complicated ask, but I am running into issues when layering. Not familiar with the platform so hoping someone can confirm. Thank you!!

[v-saisrao-msft]

Hi @evanol1543,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @evanol1543,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you

[v-saisrao-msft]

Hi @evanol1543,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[v-saisrao-msft]

Hi @evanol1543,

Thank you @kushanNa @djurecicK2, for your helpful insights.

You can do this by using the Bubble layer in Azure Maps, which displays around 40 bubbles at ZIP code locations for your sales reps, without requiring polygon borders. If you want to add more context, you can include a Filled Map layer underneath to show sales at the state level. This approach ensures the bubbles remain accurate and easy to understand.

Add a bubble layer to an Azure Maps Power BI visual - Microsoft Azure Maps | Microsoft Learn

Layers in an Azure Maps Power BI visual - Microsoft Azure Maps Power BI visual | Microsoft Learn

Filled map in Azure Maps Power BI Visual - Microsoft Azure Maps | Microsoft Learn

Thank you.

[kushanNa · Accepted solution]

Hi @evanol1543   

Have you tried icon maps?
https://community.fabric.microsoft.com/t5/Desktop/How-to-add-bubble-over-Shape-map/td-p/2473075

If that doesn’t work, I would suggest creating your own visual. You can use HTML content to create any visual you like in Power BI.

I have attached a sample PBIX file for your reference.

[djurecicK2]

Hi @evanol1543 ,

 Not sure if I understand the requirements exactly. There are ~42,000 zip codes in the US, I would think that you want to show zip codes as the map is zoomed in, right?  

I would look into the ArcGIS visual- you may need a paid subscription. Here is some additional information:

https://www.youtube.com/watch?v=-izRcDYGR1g

Azure maps has gotten better over time also:

https://www.youtube.com/watch?v=yoxJz6QFd-4

[evanol1543]

Thank you for the reply. To clarify, I only need around 40 bubbles to be present, representing the territories where are sales representatives live. I do not need an accurate border for the zip code, only for the bubble to be mostly directionally accurate.