Multivariate Bubble Map or Heatmap

[doctaphil89]

I have a dataset with location (zip, lat/long) and a categorical status for each row (Open/Closed.)

I have been through a plethora of stock and third party apps and cannot accomplish being able to convey size/density per location for BOTH variables. Ever since a recent update, default Map visual bubbles are opaque and the bubbles becomes a pie chart when representing multiple variable values. I have also tried Filled Map, Mapbox, and Chloropleth and I can't find a visual that won't summarize the Open/Closed variable.

Ideally, I would like to control the size or density of the bubble/heatmap with the Count and then choose the color or gradient for each value of the variable.

[v-deddai1-msft]

Hi @doctaphil89 ,

I can't find any map visual that you can put multiple values in size field. Maybe you need to find a aggregation between Open/Closed. Or you can create an idea for it  in

https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.

Best Regards,

Dedmon Dai

[amitchandak]

@doctaphil89 , Have you checked, Azure Map. If not check if this can help

https://docs.microsoft.com/en-us/azure/azure-maps/power-bi-visual-understanding-layers