Forum Discussion

Lopez0083's avatar
Lopez0083
New Member
1 year ago
Solved

Why Does Map Visualization Reduce Points When Using "Average of Latitude and Longitude"?

Hello Power BI Community, I am trying to create map visualizations using a dataset with unique combinations of custom labels, latitude, and longitude. However, I encountered an issue that I hope yo...
  • timalbers's avatar
    1 year ago

    Hi Lopez0083 ,

     

    if you select "Average" as summarization, you will receive only the average value for each "CustomLabel" dimension.

    So within each category of "CustomLabel" the model calculates the average value, which leads to having only one value of latitude and longitude for each value in "CustomLabel".

     

    This is also the reason why the points in your map are moving more towards the center of the map.

     

    Hope this helps