Forum Discussion

Niel007's avatar
Niel007
Regular Visitor
6 years ago
Solved

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. How...
General Comment
Need Help
Show and Tell
  • MariaP's avatar
    MariaP
    6 years ago

    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

MariaP's avatar
MariaP
Solution Supplier
6 years ago

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