Custom Hierarchy for Map Visual.

[Anonymous]

Hi All,

So, my problem is that I have lats and longs of 600+ locations and I want to group these under :
1) 4 zones - East, West, North, and South.

2) 30+ towns 

3) Location, true to Lat and Long.

Then I want to display these 4 zones on a map visual and be able to drill down to town and then to location.

For example: If I select West Zone, the map should drill down to all the towns in west zone, then when I select a town, the map should show me all the locations under that town(from the lats and longs in the data).

Thanks in Advance 🙂

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i create a simple sample to test:

Then i define the Zone and Town's policy by creating calculated columns:

Zone = 
SWITCH (
    TRUE,
    'Table'[Latitude] > -50
        && 'Table'[Latitude] < -0
        && 'Table'[Longitude] > -100
        && 'Table'[Longitude] < -50, "South",
    'Table'[Latitude] > 30
        && 'Table'[Latitude] < 50
        && 'Table'[Longitude] > 70
        && 'Table'[Longitude] < 120, "East",
    'Table'[Latitude] > 50
        && 'Table'[Latitude] < 100
        && 'Table'[Longitude] > -50
        && 'Table'[Longitude] < 0, "North",
    'Table'[Latitude] > 50
        && 'Table'[Latitude] < 100
        && 'Table'[Longitude] > -200
        && 'Table'[Longitude] < -150, "West"
)

Zone = 
SWITCH (
    TRUE,
    'Table'[Latitude] > -50
        && 'Table'[Latitude] < -0
        && 'Table'[Longitude] > -100
        && 'Table'[Longitude] < -50, "South",
    'Table'[Latitude] > 30
        && 'Table'[Latitude] < 50
        && 'Table'[Longitude] > 70
        && 'Table'[Longitude] < 120, "East",
    'Table'[Latitude] > 50
        && 'Table'[Latitude] < 100
        && 'Table'[Longitude] > -50
        && 'Table'[Longitude] < 0, "North",
    'Table'[Latitude] > 50
        && 'Table'[Latitude] < 100
        && 'Table'[Longitude] > -200
        && 'Table'[Longitude] < -150, "West"
)

When you choose Zone and Town as slicer, it shows all the locations of Town and Zone:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi

[Greg_Deckler]

Hmm, well Location will accept a hierarchy in the standard map visuals but I don't think it will recognize east, west, etc.