Map with multiple locations

[rodieade]

Hello

I am building a map using the  Filled map visual.

In my data set I have one column for the location, But  I have some rows which have multiple locations - example "France Germany UK".

The report will only display the 1st one ; how can I change that?

Thanks

[amitchandak]

@rodieade , Not very clear. Filter top 1.

example of measure

CALCULATE([Measure], TOPN(10, ALL(Table[location ID]), [Measure]), values(Table[location ID]))

or you can use visual level top filter

[themistoklis · Accepted solution]

@rodieade 

This thread will probably help

On Power Query editor, split Column values by the delimiter and on advanced options select ' split into rows'

Then plot the countries on a map

https://community.powerbi.com/t5/Desktop/How-to-split-the-the-Column-into-Multiple-rows/m-p/255014#M...