Forum Discussion

teatree's avatar
teatree
Frequent Visitor
10 years ago
Solved

Help with Power BI maps

Hi there,   I'm new to Power BI and I'm trying to plot some data onto a map of the UK.   I currently have the postcode/county/town and can convert these into longitude/latitude if required but I ...
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    teatree

     

    In this scenario, you can create a hierarchy and use the “Drill” function. Please refer to followings steps:

    1. Right click the highest level (e.g. Country) and click ‘New hierarchy’.
    2. Select other columns with lower levels and click ‘Add to Country Hierarchy’.
    3. Drag ‘Country Hierarchy’ to Location of Map chart. Turn on Drill Mode and then you can drill down by click a specific circle (area) it then breaks down by specific circles (location).
teatree's avatar
teatree
Frequent Visitor
10 years ago

ankitpatira

 

Thanks for responding. 

 

The data I have at the moment has already been categorised as below. 

 

 

On the map, it shows as below. 

 

 

I would like to know if it's possible to have one circle with the value inside for the UK, and then when zooming in further it would break down in terms of hierarchy?

 

So, country -> region -> county -> local authority -> postcode

 

I hope this makes sense

 

Thank you

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

teatree

 

In this scenario, you can create a hierarchy and use the “Drill” function. Please refer to followings steps:

  1. Right click the highest level (e.g. Country) and click ‘New hierarchy’.
  2. Select other columns with lower levels and click ‘Add to Country Hierarchy’.
  3. Drag ‘Country Hierarchy’ to Location of Map chart. Turn on Drill Mode and then you can drill down by click a specific circle (area) it then breaks down by specific circles (location).