Category Hierarchy on map drill-down

[MarcPomes]

Hi all,

I have a question with map category. I activated the drill down option and press the UK as a country. Then, I could see the following cities. Until here, everything works perfect. My question is if you know any way to only show "city", rather than "city, country".

My fields have data categories as Country, City and Post Code.

[Anonymous]

Hi @MarcPomes ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous · Accepted solution]

Hi @MarcPomes ,

Please take a look at the differences between the drill-down buttons as shown below:

Here is the pbix file here.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[themistoklis]

@MarcPomes 

How are the cities stored in the dataset that you are using?

Are they stored with the format City, Country?

Maybe it is a data issue and not a visual one

[MarcPomes]

Hi @themistoklis ,

The cities are stored only by name. If I use a Map object only with cities, I don't have that problem. It appears when I activate the drill down option with the country on the first position. Is it possible to desactivate this automaticaaly concatenate?

Thank you

Marc

[themistoklis]

@MarcPomes 

Unfortunately there is no option to prevent dimensions from showing as comma seperated labels when you use the drill down option.

You can submit an idea if you want on PowerBI community