Forum Discussion
Map
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.
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.
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.