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

Question

Hi Community,I am facing an issue with the Azure Map visual in Power BI where numeric field values are being automatically aggregated (summed), even though the data is at the job level (i.e., every entry/row is unique per job).The Problem: When I plot multiple job locations on the map and display a numeric field (e.g., Market Value), the visual sums up the values instead of showing the individual value for each job. This is incorrect behavior since each job already has a unique record.What I Have Already Tried:Changed the data type of the field from Numeric to Text — did not workCreated a DAX measure using CALCULATE with ALLEXCEPT to force job-level context — did not workSet the Default Summarization to None in the model — did not workExpected Behavior: Each pin/bubble on the map should display its own individual job-level value, not an aggregated sum of all visible jobs.Has anyone faced this issue or found a workaround? Any help would be greatly appreciated.Thank you!

mfelix · Answer

Hi&nbsp;Vaibhav_99&nbsp;,
&nbsp;
When you refer that the information is individual at each job do you mean each job location, or a location can have multiple jobs?
&nbsp;
I'm asking this because if you only have one job per location the sum of the values is the same has that row so the aggregation is in fact a single value, however if you have more than&nbsp; one job per location then this is the expected behaviour since the map is aggregating the information at values level because you cannot have details.
&nbsp;
Having more than one value then you need to turn place values on the legend so you can get the details inside each job location.

trivedisunita · Answer

Hi&nbsp;Vaibhav_99&nbsp;,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.&nbsp;Hope this helps!&nbsp;Thank you.

v-saisrao-msft · Answer

Hi&nbsp;Vaibhav_99,
Have you had a chance to review the solution we shared by MFelix&nbsp;trivedisunita&nbsp;? If the issue persists, feel free to reply so we can help further.

&nbsp;
Thank you.

vaibhav_99 · Answer

same location can have multiple jobs and also in legend i am using propertytype and in tooltip i am using jobid&nbsp;MFelix&nbsp;

vaibhav_99 · Answer

same location can have multiple jobs and also in legend i am using propertytype and in tooltip i am using jobid but still have the same issue&nbsp;trivedisunita&nbsp;

Forum Discussion

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

9 Replies

Related content

numeric slicer for aggregated Y axis

Aggregate in numerical order

Group by on eventstream's lakehouse target doesn't aggregate numeric fields

Data Aggregation issue

Change aggregation from default on numeric column