Assigning Multiple Countries to a Value in a Filled Map

[Anonymous]

I am a complete novice with Power BI so I apologise in advance if this a very basic question. 

I'm trying to create a filled map to highlight the different countries a TV channel broadcasts to. It works fine when it only broadcasts to a single country but when a channel goes to multiple it will only highlight one on the map. 

I have tried keeping the countries in one column and separating them by a comma and I have also tried spliting them into different columns as in the example below, but it still only returns one country. 

Any help would be hugely appreciated. 

[deldersveld]

You should be able to add each country as it's own row. Leave Country in Location and remove Regions. If Denmark and Sweden have the same value for Channel name, then they should both appear filled.

[Anonymous]

Thanks for responding. 

This works and will highlight the countries but is that the only way to do it as I will need to create a new row for every channel for every country it broadcasts to?

[deldersveld · Accepted solution]

If you are working from a comma-separated list of countries, you can go into the Query Editor, then split the columns by each occurence of the comma delimiter. This creates a separate column for each country. You can then unpivot the new columns so that each country ends up on its own row for each channel so you won't have to do it manually.

Here's a sample sequence if your starting data looks like this:

 

 

 

 

Then "Close and Apply" and setup your Filled Map with the country ("Value" in the screenshot but which I would typically rename)

[Anonymous]

Thank you, that's great!

[Sean]

@Anonymous

You can automate this in the Query Editor

If you have a Channel column and then a column listing all countries per channel separated by ,

Split Column by delimiter - clean and trim the new columns - Unpivot the channel column - Close and Apply