You should choose the geographic role of your [Borough] as County/District instead of City then hopefully it will be fixed. Give a try and let us know if this help.
Thanks for your response.
I am assuming you meant to change the heading in my csv. file, right?
I have changed it, but it has not changed anything. It still says that there are 25 unknown when I add the Number of Records pill onto Colour.
I do not see why it changes when I do this because boroughs remain unchanged.
Sorry If you didn't get my point. I will explain again, you need to assign the geographic role of County/District to your [Borough] field.
You can right click on your field and choose the geographic role like this
Don't change the source header for City to County/District.
As you can see the geo role for City field is assigned to City like wise in your case [Borough] should be County.
Hope you get my point
Thanks for getting back to me.
I did what you said.
But it didn't work. Now all of my London boroughs disappeared, only leaving City of London.
All other boroughs are left as unknowns.
I have also made changes to my .csv file re-uploaded that to the geocoding.
Do you have any idea why it still may not be working?
Ooops IF possible could you please share some sample mock up data in a packaged workbook. I'm curious to look into it.
I somehow managed to make it work!
I do not know how but somehow Borough showed up in the list of options in Geographic Role.
I want to try and make it a filled map but for some reason, I cannot get it to work.
London Borough.csv.zip 816 bytes
Thank you so much for your help! I am glad that all my boroughs show up and all work fine now.
I am trying to make it a filled map rather than have the boroughs come up as plots. Whenever I click on the filled maps part, it just makes it a plot again.
Do you know how to do this?
Updated twbx. file: https://drive.google.com/open?id=1K_MrQ00_zLIRcSbHp_-clnJ9G95Cc29Z