How can we restrict a country when placing cities on a map chart

[Anonymous]

Hello,

In the context of my work, I want to put the French cities on a map chart, my problem is that power bi places French cities around the world because normally the same city name can exist in several countries
how can we force power-bi desktop to take just french cities ?  there is a code that i should respect ?

ps : i'm using an oline connexion and i dan't change the field category 

[v-lili6-msft]

hi, @Anonymous 

Just add country column:

Country = "France"

Then darg into the highest level in the City

Now expand the visual.

Result:

And I also filter the city.

Regards,

Lin

[Anonymous]

thank you @v-lili6-msft  for the time you took to answer my question, in fact I tried this solution before writing my question and it did not work for me (it may be a problem of vesrion power bi ? i have the May 2019 version)

this is what i get when i drill down to city

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

Just use Expand all fields at once instead of Drill down in the map visual.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill#expand-all-fields-at-once

Regards,

Lin

[Anonymous]

thank you very much  @v-lili6-msft  for the time spent simulating my problem. Indeed I followed your demonsttation and it solved the problem