Represent two datasets on a map

[adammaro]

Hello,

I am a newbie into PowerBI.

I have a set of data that I want to represent on a map.

DATASET1: Location, Sales per location, Manager
DATASET2: Location, Manager.

I would like to have a map with the DATASET2 as black squares and the DATASET1 as a heatmap depending on the number of sales.

Is it possible in the PowerBI map?

DATASET1

City	Country	Sales	Person
Kyoto	Japan	1000	Tim
Buenos Aires	Argentina	2000	Antonio
Cape Town	South Africa	1400	John
Prague	Czech Republic	2000	Daniel
Reykjavík	Iceland	3000	Benjamin
Seattle	USA	1000	Nicola
Marrakech	Morocco	3040	Wendy
Helsinki	Finland	3000	Wendy
Kuala Lumpur	Malaysia	2000	John
Lisbon	Portugal	1000	John

 
DATASET2:

City	Country	Person
Pretoria	South Africa	Tim
Sidney	Australia	Antonio
Porto	Portugal	John
Washington	USA	Daniel
Marrakech	Morocco	Benjamin
Stockholm	Sweden	Nicola
Buenos Aires	Argentina	Wendy

Thanks for any help and suggestions.

Antonio

[rajendraongole1]

Hi @adammaro  - Yes, it's possible to achieve what you're describing in Power BI with maps!

Please find the attached pbix file. 

I have used append and combined both dataset to one. now we can report country in map visual

Hope this helps.

[adammaro]

Hello @rajendraongole1 

thanks for the reply. However, the graph you shared does not exactly do what I asked.

I was looking to have the two dataset represented, and I can only see the DATASET 1:

Whilst I am looking for a solution that shows both sales (bubble) and client manager (black dots)

Thanks,

Antonio