Problem using town/area data in map visual.

[sarah2_williams]

Hi all,

Has anyone come across this problem before and found a solution. I'm trying to plot UK Regions on the map visual, but as there are Regions in other countries with the same name it is spreading the information all over the map, rather than just in the UK. as an example there is a Worcester, Portsmouth and Gloucester in the US and in the UK, for my map visial it has highlighted the US location rather than UK. I have attached a screen shot of the visual and the data it is coming from (which we got from ONS).

I then have a numberical value per region to add in later. 

We have tried filtering using the other fields in the data, but nothing seems to make it move all the points to the UK part of the Map. has anyone found a way around this?

Thanks

Sarah

[Brunner_BI]

What you need to do here is add another column that says "UK" then you add that on top of the field you currently have in your map and then do a drilldown like this so that it will remember to only search within the UK.