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 All!
I am currently looking to represent two data-sets in a Map visual of Power BI.
One of the data sets is 'Transactions' per Country and I am able to successfully show it on Map visual. However, I need to show 'Employee Count' per Country aswell.
I would like to minimize the number of visuals used. So, would like to show both the data-sets in the same visual. Can anyone guide?
Solved! Go to Solution.
Hi @Niel007
Depending on the size of your dataset you could try to append both tables together and then merge the Transaction Column and the Employee Count column. You can then plot your values on the map with the 'Merged' column in the size Field of the map visual. I have also createda measure type for each column to identify the types of counts being displayed.
See sample file DOWNLOAD SAMPLE if needed.
This may not however be viable if you have large amounts of data.
Cheers,
Maria
Hi @Niel007
Depending on the size of your dataset you could try to append both tables together and then merge the Transaction Column and the Employee Count column. You can then plot your values on the map with the 'Merged' column in the size Field of the map visual. I have also createda measure type for each column to identify the types of counts being displayed.
See sample file DOWNLOAD SAMPLE if needed.
This may not however be viable if you have large amounts of data.
Cheers,
Maria
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |