Filled Maps using one or more regions per entry

[juicepaper]

Hi I was trying to input multiple countries that make up a region in a filled map ie.
| Bill | Location|
---------------

|Joe | Africa, Europe|

|Bob | North America|

But it just fills in one region (for Africa, Europe, it just does Africa). Is there any way around this?

[v-sihou-msft · Accepted solution]

@juicepaper

No, it's not possible to read multiple countries included in a single cell. You have to split it into multiple columns in Query Editor.

Regards,