Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MischaT
Frequent Visitor

GIS Data Plotting (Multiple Tables)

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: 

IDEpicenter TypeGPS LatGPS Long
A1Hailstormxxxx
B1Fogxxxx
C1Mistxxxx
D1Hailstormxxxx

 

Shops Data Set

Shop TypeShop NameGPS LatGPS Long
FlowerJasmin's Shopxxxx
WoodJEP Woodxxxx
SteelAll Steel Co.xxxx
FoodIhungryxxxx

 

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!!

1 ACCEPTED 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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

8 REPLIES 8
Greg_Deckler
Super User
Super User

@MischaT I have created a couple different measures that should help:

Going the Distance - Microsoft Power BI Community

Near - Microsoft Power BI Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@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"
    )
  )
   

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors