Forum Discussion

Newcolator's avatar
Newcolator
Icon for Helper II rankHelper II
5 years ago

UK FIlled Maps by County

Hello. I'm trying to make a filled map of the UK by county. I am able to get this to work by having a column with the name of the county, then setting the data category on that column to "county". Th...
Need Help
desmon316's avatar
desmon316
Frequent Visitor
2 years ago

Hi, I know I am very late to the conversation, but I wanted to comment on this to help future users. Power BI does not only look at Ceremonial counties but also looks at administrative counties. I set up an excel file with postcodes by splitting postcodes and using the first part of the post code. For example: I used AB0 instead of AB0 0AA and assigned that post code to a County, Region and Country. 

 

All the counties and admin counties can be found from https://www.doogal.co.uk/AdministrativeAreas

 

Regards

 

Desmond