Hi,
I've got data for my organisation that I want to populate on a Filled Map.
I'm looking to map the data to their respective Counties, which I'm doing using our location's Postcodes and linking it with data retrieved from Doogal for supplementary information.
The key thing to note is that all my locations are in the UK.
The issue I have is that the map doesn't fill out the entire County correctly.
I've tried many different ways to get this to work, and each presents different problems.
1) Categorising a County as a County
While this works in most cases, there are situations where a County like Berkshire is pulling up somewhere in the US, which I don't want it to do. I even tried adding a suffix of ", UK" to each of my Counties, which did nothing.
2) Using Latitude and Longitude
If I try using the Latitude and Longitude of my Postcodes, each County has a list of multiple different Latitude and Longitudes. This then causes a big problem because Power BI wants to aggregate them somehow, and no matter which way I do it (Min, Max, Avg, etc) it won't cover the entire area the County covers on the map.
Is there a way I can do this? It seems like something that should be doable, but I can't figure it out.
