Town and Country showing US and not UK postcodes on a Map

[SachinC]

Hi,

I have a dilema. My PowerBI 'Map' is showing Boston and Halifax in the USA.  

I've tried to create a DAX query, Town Country = [Town]&", "&[country] where Town are values such as Boston, Halifax and Country is fixed to be UK, but this didn't work. 

Please help?

Thanks

[vanessafvg]

@SachinC have you changed the data categories? ie what is field categorised as , if you look in the modelling tab of the visual pane

[SachinC]

Yes I did. The field came up with a globe as a result. Please help, I am lost! Thanks.

[vanessafvg]

@SachinC  please show me what your data looks like, copy and paste?

[SachinC · Accepted solution]

Got it sorted in the end. I used the modelling. Thanks.