Multiple datasets in maps

[Anonymous]

Hello everyone, I have a question about showing multiple datasets on the map.

I have a list of activities and for each one I need to show participating countries that differ from one to another. I'm pulling the data from Excel where people entering there activities and participating counties (binary 1/0 answers for each country and activity).

I am using Filled map in PowerBi and it doesn't let me upload more that one column of data (which is the data set of the first country only).

Any suggestions on how to organize the entering of such data in Excel and how to show it in PowerBi?

Thanks in advance!

[Greg_Deckler · Accepted solution]

So how is the data laid out?

Like

Activity,Country1,Country2,Country3,Country4

Activity 1,1,0,0,1

Or

Country,Activity1,Activity2,Activity3,Activity4

Country1,1,0,0,1

Regardless, it should be something like:

Country,Activity,Value

Country1,Activity1,1

Country1,Activity2,0

Country1,Activity3,0

Country1,Activity4,1

Country2,Activity1,1

...

If it is in that form, you should be good to go. You can use Unpivot to unpivot your columns in Power Query.

[Anonymous]

Thanks, @Greg_Deckler , it's working!

[Greg_Deckler]

Awesome, that was a guess on my part as to what was going on, glad I guessed correctly!! 🙂