Forum Discussion

rohanjha1988's avatar
rohanjha1988
Helper II
5 years ago
Solved

Map with Lat Long

Dear All,

 

I have a table in which we have details of lat - long of all our clients are given. In another table we have details of sales. Can we show the sales as a bubble on map based on the lat long? 

 

Kindly guide. 

  • themistoklis's avatar
    themistoklis
    5 years ago

    rohanjha1988 

    You should use the visual called 'Map'

     

    When you add Lat and Lond then click on the drop down arrow and select 'Dont Summarise'

    See image below

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi rohanjha1988 

    Yes, you can as long as these two tables have a relation.

    Add the sales column in Size field.

     

    • rohanjha1988's avatar
      rohanjha1988
      Helper II

      Pranit, my sheets are linked. But 2 question/query - 

       

      1. The power bi is taking the lat long columns as numbers. How to change this?

      2. Which map to use? 

       

      Pls help

      • themistoklis's avatar
        themistoklis
        Community Champion

        rohanjha1988 

        You should use the visual called 'Map'

         

        When you add Lat and Lond then click on the drop down arrow and select 'Dont Summarise'

        See image below