Forum Discussion
GIS Data Plotting (Multiple Tables)
MischaT Well, for the 2nd one you could create a slicer for the distance and use SELECTEDVALUE to grab that value in a VAR and use that in the formula versus hard coding it.
I think I would need sample data to play with in order to take this further.
Greg_Deckler, please do excuse if I am missing something. I am relatively new to Power BI.
I cannot insert GPS Coordinates from two different sheets into the field wells. It results in an error. I am assuming this is because it cannot then determine which LAT fits with which LONG.
My epicenter dataset (see above) is directly linked to an application and thus, we cannot change the way in which this is exported (cannot automatically throw this into the 'shops' data set).
It will thus always export into a seperate sheet.
My question is then: How can I insert two different maps' GPS coordinates into one map?
Does this make sense?
MischaT Well, if it were me, I would do this:
New Table =
UNION(
ADDCOLUMNS(
SELECTCOLUMNS(ALL('Epicenters'),"Name",[Name],"Type",[Epicenter Type],"GPS Lat",[GPS Lat],"GPS Long",[GPS Long]),
"Category","Epicenter"
),
ADDCOLUMNS(
SELECTCOLUMNS(ALL('Shops'),"Name",[Shop Name],"Type",[Shop Type],"GPS Lat",[GPS Lat],"GPS Long",[GPS Long]),
"Category","Shop"
)
)
Hi Greg_Deckler ,
Thank you kindly for all you assistance.
I am a few steps closer, although not there yet.
Although the UNION table was successful in plotting both epicenter and site on one map, I have encountered the following problems:
1) I cannot create a relationship between the ID numbers on the epicenter sheet and the new UNION sheet. This is because it has circular dependency. This means that although I can plot the map, I cannot associate this to any other data.
2) Although a solution was provided as to how we can determine distance from the site to the epicenter, I would like the distance to be interactive (so the client can select the ID from the epicenter sheet, AND the referred distance from the epicenter). This should then be shown on the map.
3) Once a certain ID is chosen on a slicer, it ONLY shows the epicenter. It does not show the surrounding sites (again, adding to the issue of choosing the distance from the epicenter and then only showing the sites in that parameter).
I would like to know if my idea is possible to create on Power BI or if there are limitations in making this viable?
much appreciated as always 🙂
MischaT Well, for the 2nd one you could create a slicer for the distance and use SELECTEDVALUE to grab that value in a VAR and use that in the formula versus hard coding it.
I think I would need sample data to play with in order to take this further.
MischaT Another thought on this. You could solve the circular dependency issue by doing the UNION as an Append query in Power Query Editor instead.