Forum Discussion
overlay two different coordinate dataset in one map
- Anonymous9 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"
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).
Thanks a lot. This is very helpful. I just voted and if I may ask, at what point is the filtering applied: before getting data into power bi or after getting the data before I introduded a filter to display point less than 1000 and it still did not work.
I am also interested in the personal custom visual, any guide will be helpful.
Regards,
Kunle