Map with Static and Dynamic (date/time) data

[Anonymous]

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

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

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 🙂

[v-yuaj-msft · Accepted solution]

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]

@v-yuaj-msft 

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

[v-yuaj-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Yuna