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". Then I can use it on the map. But I have gaps in my map where my county names arn't recognised, or they have been placed on the map in America. Where do I find the list of county names that PowerBI is expecting for the UK?

Need Help

6 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Newcolator ,

     

    it would be helpful if you show your problem with screenshots. This makes it easier to understand.

    The country names and coordinates are sent to Bing and the areas are mapped accordingly.

     

    So chose your names like US-Bing understands it and it should recognize it. Also, the more information you give, the better Bing can combine the data with the map.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • Newcolator's avatar
    Newcolator
    Icon for Helper II rankHelper II
    5 years ago

    Firstly, here's the UK map Power BI has produced. There are white gaps where the county has not been mapped.

    Norfolk, UK is being mapped to Norfolk in the US.

    And several counties are being mapped to India. I think this might be a default when the county is not mapped.

    Surely there must be a list of the expected names? As it is the mapping is redundant.

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

    Some of the counties that bing maps seem wrong to me. Wiltshire for example, should look like this. Notice it fullly encompasses Swindon at the top.

    Bing thinks Wiltshire looks like this. It's the same shape, but missing a chunk at the top. Swindon is not in Wilshire according to bing maps.

     

     

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

    This is Roxburhshire in Scotland.

    Search for it in Bing maps and you don't get a county outline, just a pin.

     

    And Power BI shows it as the whole of Scotland.

     

    It looks to me as if Microsoft haven't got UK county mapping right in Bing.

  • 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