UK cities are showing in the US in map report

[ansa_naz]

Hi all

I need to create a filled map report which shows the number of buildings per UK city that we look after. However, for some reason, some of the buildings show up in the US instead of the UK. I am not sure how to change this.

My columns of data are as follows:

Building ID - a unique ID for the building

City - Name of city in which building is located, eg Lincoln

Country - Name of country in which building is located. This is always UK as all buildings are in the UK

Zipcode - this is the postcode where the building is located

I have tried the following in the report:

- Added the City field to the Location box, and also added City field to the Colour Saturation box. This does not work - Lincoln shows in the US.

- Added Country to the Location box, and then City below Country in the Location box as a sub-location. I added City into the Colour Saturation box. This did not work, because Lincoln shows in the US when I drilldown from the country level into the City level

- I combined City and Country fields into one field, eg 'Lincoln, UK' and called it 'Location'. I then add this 'Location' field into the Location box, and also added it to the Color Saturation box. This doesnt display anything on the map at all.

How can I force cities which currently show in the US, to instead show in the UK?

All help most appreciated

Cheers

[v-sihou-msft · Accepted solution]

@ansa_naz

If you’re using Import mode, please make sure you’ve saved your dataset after combine City and Country fields into one field. And then click ‘Refresh’ in Power BI to get the latest data.

I can get this problem solved with your third step. My Power BI version is 2.36.4434.362 64-bit (June 2016)

Regards,

[v-sihou-msft · Accepted solution]

@ansa_naz

If you’re using Import mode, please make sure you’ve saved your dataset after combine City and Country fields into one field. And then click ‘Refresh’ in Power BI to get the latest data.

I can get this problem solved with your third step. My Power BI version is 2.36.4434.362 64-bit (June 2016)

Regards,

[ansa_naz · Accepted solution]

---

@Simon_Hou wrote:

@ansa_naz

If you’re using Import mode, please make sure you’ve saved your dataset after combine City and Country fields into one field. And then click ‘Refresh’ in Power BI to get the latest data.

I can get this problem solved with your third step. My Power BI version is 2.36.4434.362 64-bit (June 2016)

Regards,

---

Hi Simon

Just realised that the column name needs to be 'City' - a column name of 'Location' does not work. After changing the column name, it is now all working!! Cheers!!

[Lukeh1]

Tried this and it's still putting berkshire, UK in the east coast of North America. Well worth the premium price tag each month

[Anonymous]

I find it interesting that I struggled to get the concatenated "City, Country" to work. But as soon as I changed the field name to "Location" it worked.

Not sure what the difference is, maybe version, but try both if it is not working for you.

[Lukeh1]

Just keep trying random things until something works. Yet another great workflow brought to us from Microsoft

[danno]

Hi, 

Initially I had just the name of the town or city in the UK in my dataset - this resulted in some being displayed in the US. 

I tried several options including changing the City column to include the Country as well.  However initially this just removed all data points from the map. 

It seems that the selection of the Data Categorisation is critical to ensure that Bing recognises the location correctly. 

I tried using 'City' for the data category, but no luck.  

I then change the data category to 'Place' and this works perfectly, with all data points appearing in the UK, using the format City & ", " & Country e.g. Bangor, UK

Thanks

Dan 

[Lukeh1]

I'm trying this atm and setting to place with the concatenated city/county and country seems to be yielding better results just like it doesn't say in this official documentation (The advice in which doesn't seem to work at all): Set geographic filters in Power BI Desktop for the mobile apps - Power BI | Microsoft Learn.

[jacob1701]

Man....the order of location definately matters.  After much adjusting, I finally got everything to show in the US.  The order in location from top to bottom was State, City, Zipcode, Country.  I also designated those fields as what they really are by clicking on one field (ex. city) then clicking on Modeling tab and change data category to City.

[Greg_Deckler]

Here is what I did and it is working.

Country = "United Kingdom" instead of "UK"

Added Country and then City to Location, added Building ID to Legend.