Azure Map Visual Aggregating Numeric Values Even Though Data is at Job Level

Hi Vaibhav_99 ,

The Azure Map visual is aggregating because it groups by location, not job ID.

Azure Map visual groups data points by geographic coordinates. If more than one job exists at the same location, the numeric field is aggregated even if you set “None,” the visual still requires an aggregation when multiple rows map to the same point.To fix this, add Job ID (or another unique field) to the legend or tooltip so each job’s value is displayed individually.

Also Keep Market Value aggregated but add Job ID and Market Value to the Tooltip. This way, hovering over a bubble shows each job’s value. change the aggregation from sum to average.

Hope this helps!

Thank you

.