Reply
Member
Posts: 101
Registered: ‎03-04-2016
Accepted Solution

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

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


Accepted Solutions
Highlighted
Member
Posts: 101
Registered: ‎03-04-2016

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

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

View solution in original post


All Replies
Super User
Posts: 1,503
Registered: ‎07-27-2016

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

[ Edited ]

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

Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Member
Posts: 101
Registered: ‎03-04-2016

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

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

Super User
Posts: 1,503
Registered: ‎07-27-2016

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

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

Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Highlighted
Member
Posts: 101
Registered: ‎03-04-2016

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

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