Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |