Multiple Legends in Single map

[Anonymous]

Hi,

I have a data of my service centre presence across the globe.

I have another data set of total users of my service per country across the globe.

I have created a map displaying service centre in each country.

Now I have to see both the data in the map to check where I have users and I dont have Service centres.

Is it possible to do that in single map.

It will be really help ful if some one can help with this.

[Anonymous]

Hi @Anonymous 

It can be done with the help of Perspective.

You need to have the August 2020 release and have Tabular Editor installed through Help --> External Tools

Here is the link to the steps.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives

[v-juanli-msft]

Hi @Anonymous 

You could add the location of the ervice centre presence in the "Location" field of the map, then and count of users under the "Value" field of the map.

Please read more from this article.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Maggie,

Thank you for your reply!

I have gone through the link, it has only single data set but I have multiple data set and let me re frame my doubt.

"I have a data of my electronic devices sales per country across the globe.

I have another data set of total sales of all the electronic devices across the globe.

I have created a map displaying my sales in each country.

Now I have to see both the data in the map to check where
I dont have any sales and others are selling along with my sales center detials."

Thanks in Advance

[v-juanli-msft]

Hi @Anonymous 

Do you have a table like this?

country	electronic devices	sales
a	1	10
a	2	11
a	3	12
b	4	13
b	5	14
c	6	15

Then you want to show country and sales of the electronic devices in this country in the map, right?

If not, please show me a simple example data and expected result.

Best Regards
Maggie

[Anonymous]

HI Maggie,

Really thanks for your replies, 

Please find the below details

Data set 1 Has country,Sales centre ,geo coordinates, device sold and sales  valueData set 1

Data set 2 has country and device sold in the country (Generic Data not my sales)

Data set 2

Using Data set 1 

I created a map showing sales of device in the country and located with the geo coordinates.

Now I want to include the second data set details in the same map to see country wise usage of device as well as my sales in the country.

For eg; In Chile people are using all three device where am selling only TV.

So to visualize it, I need to mark the whole chile in three Colours one for each device and I need to pin point my sales centre using geo coordinates.

Out should be like this , where the fill map style is representing the county and device used blue dots are my sales centers.

Output in maps

[v-juanli-msft]

Hi @Anonymous 

You could add the location of the ervice centre presence in the "Location" field of the map, then and count of users under the "Value" field of the map.

Please read more from this article.

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.