Help with Filled Map - multiple value is location and colour saturation field

Hi ShanTheMan

yes, you can do that with these steps:

1) in Powerquery split the Country expertise column by separator

2) unpivot all the columns that will be generated by 1) into one column

Please make sure that the duplicate data that will be generated by 2) does not affect other parts of your data model

e.g. if your data now looks like this

Consultant | CountryExpertise

Bob | Sudan;China;Brazil

Peter | USA

will look like this after 1):

Consultant | CountryExpertise1 | CountryExpertise2 | CountryExpertise3

Bob | Sudan | China | Brazil

Peter | USA

and finally like this after 2)

Consultant | CountryExpertise

Bob | Sudan

Bob | China

Bob | Brazil

Peter | USA

HTH,

Frank