Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiple Legends in Single map

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 ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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