Forum Discussion
Map with multiple locations
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
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
2 Replies
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
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
