Hi, I am working on a report that plot geo coordinate on a map and overly another geo coordinate on the same map. How can I do this on power BI?

You can append two datasets into a single one with columns: lat | long | set where lat and long would be coordinates and set would be a differentiator for your geographical layers. Then simply use Map visual as follows: Sample map with "layers"

overlay two different coordinate dataset in one map

5 Replies

Anonymous
Not applicable
9 years ago
You can append two datasets into a single one with columns:

lat | long | set

where lat and long would be coordinates and set would be a differentiator for your geographical layers. Then simply use Map visual as follows:

Sample map with "layers"
- kunlemic
  Regular Visitor
  9 years ago
  Anonymous
  
  Thanks for the assistance again and it worked just right but I noticed that when I have large data, only one set is showing. Please is there any limitation to the size of data that this principle can work with.
  
  Regards,
  
  Kunle
  - Anonymous
    Not applicable
    9 years ago
    Unfortunately, yes, there is a limit of 3500 points you can display on the map visual at the same time. So you need to use some data filtering to limit the number of points to display. You can vote here if you would like Microsoft to change it: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7394290-allow-more-data-points-to-be-displayed-on-a-map. Otherwise you would have to create your own custom visual I guess (needs code development).
- Anonymous
  Not applicable
  8 years ago
  The layout changed since the last update. Is this methode still possible?

Forum Discussion

overlay two different coordinate dataset in one map

5 Replies

Related content

Coordinates

Map overlay for same coordinates but different sizes

Overlay Transparent Images

Convert between different coordinate map system

Overlay two maps