Show Total by Reference Layer Region in Azure Maps

[LeverPowerCLiff]

Hi,
I have a list of data points with their longitude and latitude that I am plotting on an Azure map. There are hundreds of points (though the example only shows less for clarity) so I want to show them by region, so I found and imported a geoJSON file that I am applying as a reference layer. Can I show the sum of all points in a given region and colour code them?

For example I want to show the points in Scotland summed together and colour code the regions by their value.

The regions show as orange as that is the colour I set as unmapped. 

I wanted to try to add a column for the region for each data point but I couldn't work out how to get the region of a point from the longitude and the latitude from the geoJSON file but I don't even know if this would be a fix.

Thank you for any help.

[Anonymous]

Hi @LeverPowerCLiff ,
Based on my testing, you can start by creating a region column based on latitude and longitude ranges

Region = 
SWITCH(
    TRUE(),
    'Table'[LATITUDE] >= 54.6333 && 'Table'[LATITUDE] <= 60.8607 && 'Table'[LONGITUDE] >= -7.5722 && 'Table'[LONGITUDE] <= -0.7889 , "Scotland",
    'Table'[LATITUDE] >= 49 && 'Table'[LATITUDE] <= 55 && 'Table'[LONGITUDE] >= -6 && 'Table'[LONGITUDE] <= 2, "England"
)

Go to format visal ->filed map ->Color

Set the size as value

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[LeverPowerCLiff]

I'm trying to use the regions in the reference layer that can be seen in the image above. For e.g. North West, Greater London, etc. not just the countries of the UK. 

Also with my number of points, I think simplyfying Scotland into a rectangle will cause issues with points allocated the wrong country.

[Anonymous]

Hi @LeverPowerCLiff ,
If you don't divide it in rectangles, you need to have the name of each location and a table of the corresponding areas, which can also be achieved by placing the name in the LOCATION box

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly