Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I would love some community help again 🙂
What I want to do:
I have a 'Epicenter' Data Set and 'Shops' Data set.
I would like to build a dashboard where I can 1) select the ID of a certain epicenter from the 'Epicenter' dataset, and 2) choose a radius (let's say 5km).
I would like to then 1) see the chosen epicenter point on the map and 2) all the shops in a 5 km radius.
I would like this radius to be on a slicer so that the clients can choose their prefered radius from the epicenter.
Epicenter Data Set:
ID | Epicenter Type | GPS Lat | GPS Long |
A1 | Hailstorm | xx | xx |
B1 | Fog | xx | xx |
C1 | Mist | xx | xx |
D1 | Hailstorm | xx | xx |
Shops Data Set
Shop Type | Shop Name | GPS Lat | GPS Long |
Flower | Jasmin's Shop | xx | xx |
Wood | JEP Wood | xx | xx |
Steel | All Steel Co. | xx | xx |
Food | Ihungry | xx | xx |
The 'Epicenter' Data Set will be refreshed daily and new information will be added
The 'Shops' Data set will remain static as I only have a set of clients at this point
I have done some research, but I have come up empty.
Does anyone have any suggestions that could help?
Guidance would be highly appreciated!!
Solved! Go to Solution.
@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 I have created a couple different measures that should help:
Going the Distance - Microsoft Power BI Community
Near - Microsoft Power BI Community
Hi Greg,
Thanks for the tips.
Any suggestions on how to use the two graphs' GPS Coordinates?
Kind Regards
@MischaT Well, if they are lat and long then mark their data categories as such and then use them in Latitude and Longitude field wells in map visuals. Or am I missing something?
@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 Another thought on this. You could solve the circular dependency issue by doing the UNION as an Append query in Power Query Editor instead.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |