Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using ArcGIS maps to filter on geographic data

Hello,

 

I would like to use ArcGIS to draw a drivetime and then filter unrelated geographical sets of data.

 

For Example

1) I have a network of retail locations

2) I have a number of data sets at a geographic level (e.g. lat/long, post code, city etc.)

3) When I select a retail location I would like to filter those data sets to display the counts in seperate tables.

 

In the screenshots below I have tried to illustrate what I mean. I have selected a retail site and added a drivetime radius, I am then selecting the polygon. The table remains unfiltered while the KPI Card filters (because I have conneced the city in both tables in the relationships tab). The data in the table is at a lat/long level so cannot be joined in any meaningful way.

 

 

  • Hi Anonymous,

     

     

    I would like to use ArcGIS to draw a drivetime and then filter unrelated geographical sets of data. 


     

    Normally, we may not filter the value when there is no relationship.

     

    I cannot reproduce the scenario as yours, if it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Cherry

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Anonymous,

     

     

    I would like to use ArcGIS to draw a drivetime and then filter unrelated geographical sets of data. 


     

    Normally, we may not filter the value when there is no relationship.

     

    I cannot reproduce the scenario as yours, if it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Cherry,

       

      Thanks for your reply, I somehow missed it.

       

      I managed to speak to an internal resource who confirmed this would not be possible, there is a requirement to pre calculate any geospatial data beforehand.

       

      Kevin