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 with the data with Date/Time fields. Data is for one person doing many trips in the period Nov-20 to Apr-21. Can I add Push Pins of various locations to this?

A record has StartTime and StopTime and the Bubble size is StopTime - StartTime, meaning larger bubbles are longer journeys. Bubbles are located on the StartTime Lats/Longs.

 

Journeys will get filtered by date ranges, which can change, and I don't really want to add a 'Push Pin' for every date but thinking that's the only way to do this?

 

Happy to supply more info, any help greatly appreciated.

 

Cheers

  • 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.

     

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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
      Not applicable

      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.

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous 

        Thank you for this, I will definitely be giving this a try!!