Forum Discussion
Map
I'm adding some simple data that looks at UK counties in relation to how much they have been researched from our collection - so a simple count vs county name. I've doen this before and it worked but the lastest effort shows data in the US, so the map shows both US and UK though the data is for the UK and there is no geographic data aside from the couny name that links it to a specific location. any ideas?
Hello TNACliff ,
This is a classic Power BI mapping issue caused by ambiguous place names, especially when working with UK counties that share names with US counties or cities.
If your dataset only has "County", add a new column like:
Full Location = [County Name] & ", United Kingdom"
Use this new Full Location column in your Map visual’s Location field.
And in the column tools, if you set this as Place, it will work the best.If this solved your issue, please mark it as the accepted solution. ✅
no it did not solve the problem but if you change the data category to "state or Province" (in this case my list of counties) it works.
7 Replies
Hello TNACliff ,
This is a classic Power BI mapping issue caused by ambiguous place names, especially when working with UK counties that share names with US counties or cities.
If your dataset only has "County", add a new column like:
Full Location = [County Name] & ", United Kingdom"
Use this new Full Location column in your Map visual’s Location field.
And in the column tools, if you set this as Place, it will work the best.If this solved your issue, please mark it as the accepted solution. ✅
Hi TNACliff,
I wanted to check if you had the opportunity to review the information provided by anilelmastasi. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hi TNACliff,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi TNACliff,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
unfortunately not. there was no change, bubbles still appeared in North America and I am not sure that the places the bubbles represent are in thiose actual areas. Looking at the map now all bubbles have disappeared so wondering if this is a glitch in my powerbi - will restart and take a look later today if I get the chance.
Hi TNACliff,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
