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.
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
@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
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
104 | |
73 | |
69 | |
47 | |
47 |
User | Count |
---|---|
161 | |
85 | |
76 | |
68 | |
67 |