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.
Community ChampionMischaT 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 🙂
- Greg_Deckler
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
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.