Help needed for a Dash build

[Brookied]

Hi Guys

OK so I work for a charity in IReland and one of the major aims of a dept is to run a yearly debates event between high schools.  At the moment this is very much a pen and paper excersise. A large map is taken out of storage. coloured dots represtn the schools locations and manual acitivy to match up schools in the locale for early rounds of the event. 

My aim is to use Power BI to help take a lot of the grunt work out of this. 

So far I have been able to take a list of schools, and apply a Lat/Long co-ord in each and represt on a map inside Power BI.  Brilliant. When a coloured dot (school) is selected it returs some basic contact information and notes

Whats I am stuck on this is how to return in a different visual a list of school in the local area?

So if i know school A is in North Dublin, then in Visual 1 I get information for School A - In Visual two (a muslti row card) i get a list of school close by that School A can be teamed with. 

I have so far group school by districh or county but am now stuck.... any advise on this would be great. 

 Many Thanks

Darren

[kcantor]

@Brookied

I would start by adding a column to my query showing the region where a school existed. Then add a look up table showing all of the regions. Use your look up table as a slicer to narrow down your map results. Place all schools on a multi row card on the same page. Then it would just be a matter of selecting the region and filtering both the map and the multi row card by region.

[Brookied]

Hi -

Thanks for the response - I pretty much have in place what you mention - my next challenge is the following;

based on creating districts and assiging these to each school I can filter based on the district and see only schools in the selected district.  

What i would like to do is create a call to action that when i click one of the schools in the selected district i get a returned result of 5 schools in the same district which is randonly selected based on number of schools in said district?

So In the slicer i click a district

Map reflects the above selection and zooms into the district.  (all working)

I click on a school from the district and in a box i get a random list of 5 school in the same distirct?

Is this possible?