Forum Discussion
How to represent two data-sets in a Map visual
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?
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
1 Reply
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