Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Map with Static and Dynamic (date/time) data

Hi all,   Just wondering if it's possible to add Static Lats/Longs to the same Map that is built using data with Lats/Longs that have associated Date/Time data.   Eg This image shows the map wit...
  • Anonymous's avatar
    Anonymous
    5 years ago

    So, I found out that there are Azure Maps and I can leverage the Reference Layer feature in this map. Just follow the Getting started page to setup the map.

     

    I've managed to get the map to this point

    The Blue and Red dots are the layered data points added in via a *.json file. Code for that file

    {
      "type": "FeatureCollection",
      "features": [
    			{
    				"type": "Feature",
    				
    				"properties": {
    					"color": "Red",
    					"marker-size": "small"
    				},
    				
    				"geometry": {
    					"type": "MultiPoint",
    					"coordinates": [ [150.32385560, -26.87570000], [ 150.90156390, -27.16199722 ] ]
    				}
    			}
    			,
    			
    			
    			{
    			"type": "Feature",
    				
    				"properties": {
    					"color": "Blue",
    					"marker-size": "small"
    				},
    				
    				"geometry": {
    					"type": "MultiPoint",
    					"coordinates": [ [ 148.393306, -25.433417] ]
    				}
    			}
    			]
    }

     

    Some limitations I'm working on:

    - these layered points cannot use the OnHover tooltips

    - I still haven't worked out how to add a label of some description (very new to json)

    - making changes to the file, eg changing the color from Red to Green, then saving it don't go across to the PBI report. The file must be removed then added back it ... I need the Lats/Longs in this file to be changeable so I'll be working on this as well

     

    Hope this helps someone else 🙂

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Thanks for your sharing! Your idea is great. More people will benefit from your sharing.😊 Have you tried a custom visual called "Route Map"? I 

    I did a test. Maybe it can meet part of your needs.

    Please refer to the following links:

    Power BI Custom Visuals - Route Map - YouTube

    Power BI Custom Visuals - Route Map (pragmaticworks.com)

     

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.