Map with Lat Long

[rohanjha1988]

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. 

[pranit828]

Hi @rohanjha1988 

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

Add the sales column in Size field.

[rohanjha1988]

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 · Accepted solution]

@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