How to make a Power BI Map Drill Down Visual with the UK Regions, Area Codes, District Codes etc.

[Anonymous]

Hi,

I have a dataset that includes the Region Names, County, District, Area, Street, and Postcodes for UK addresses.

I need to create a drill-down map in Power BI. However, when I add the Region Name to the Power BI Map, it doesn't display properly.

I've been searching for a solution but haven't found anything, including a suitable GeoJSON file, in case the standard Power BI Map doesn't work.

My regions are listed below:

['North West', 'East of England', 'North East', 'South East', 'London', 'West Midlands', 'Yorkshire and the Humber', 'East Midlands', 'Wales', 'South West']

I have also shared the complete dataset, which you can download from here: https://drive.google.com/file/d/11Qkf-gfPmZyifCMdjwF10krPMbJcgQdd/view?usp=sharing

Ideally, I would like to use the Shape Map feature and give users the option to drill down into each region, county, etc., but I'm unsure how to achieve this.

[lbendlin · Accepted solution]

The "region"  and "district"  fields in your source data are not something that either of the default maps recognize as valid geographical entities

Post codes would work but there are way (way) too many.

Town kinda works

So Country-County-Town is a possible drilldown hierarchy.

It's not helped by a lot of towns being in multiple counties