Group geolocation point

Hi Anonymous,

I tested with below sample data. Please make sure there is a field that can identify each location uniquely, in my sample, it's [LocationID].

Create an extra table manually that lists all available selections. Place this field into slicer.

Please refer to below measures which should be added to HeatMap visual.

Lon measure =
VAR selectedType =
    SELECTEDVALUE ( 'Slicer Table'[quality] )
RETURN
    SWITCH (
        TRUE (),
        selectedType = "Low", ROUND ( SELECTEDVALUE ( positions[Longitude] ), 3 ),
        selectedType = "Medium", ROUND ( SELECTEDVALUE ( positions[Longitude] ), 4 ),
        selectedType = "High", ROUND ( SELECTEDVALUE ( positions[Longitude] ), 5 ),
        selectedType = BLANK (), SELECTEDVALUE ( positions[Longitude] )

Lat measure =
VAR selectedType =
    SELECTEDVALUE ( 'Slicer Table'[quality] )
RETURN
    SWITCH (
        TRUE (),
        selectedType = "Low", ROUND ( SELECTEDVALUE ( positions[Latitude] ), 3 ),
        selectedType = "Medium", ROUND ( SELECTEDVALUE ( positions[Latitude] ), 4 ),
        selectedType = "High", ROUND ( SELECTEDVALUE ( positions[Latitude] ), 5 ),
        selectedType = BLANK (), SELECTEDVALUE ( positions[Latitude] )
    )

Best regards,

Yuliana Gu