Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |