Forum Discussion

LeverPowerCLiff's avatar
LeverPowerCLiff
Frequent Visitor
1 year ago

Show Total by Reference Layer Region in Azure Maps

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
LeverPowerCLiff
Frequent Visitor
1 year ago

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's avatar
    Anonymous
    Not applicable
    1 year ago

    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