Dynamic point to polygon in ArcGIS for Power BI

[tanharahman96]

Hello!

Is it possible to display points on a map and then if a user clicks on one point it changes to show the full area (polygon) for that one selection? 

If so, could you share process?

[123abc]

Yes, it is possible to implement a dynamic point-to-polygon interaction in ArcGIS for Power BI by combining layers of point and polygon data. When a user selects a point, the corresponding polygon can be highlighted or displayed. Here’s how you can achieve this:

Steps to Create Dynamic Point-to-Polygon Interaction in ArcGIS for Power BI:

1. Prepare the Data:

   • You need two datasets: one with the points (e.g., locations or specific coordinates) and one with the polygons (areas such as regions, boundaries, etc.).
   • Ensure that there is a common field in both datasets that links points to their respective polygons (e.g., a region ID or area code).

2. Add ArcGIS Map Visual in Power BI:

   • In Power BI, go to the Visualizations pane and add the ArcGIS for Power BI visual.
   • Sign in to ArcGIS if needed to access its additional features.

3. Configure the Point Layer:

   • Drag your points data into the ArcGIS map visual.
   • Assign latitude and longitude columns to place the points accurately on the map.
   • Customize the appearance of the points (e.g., size, color).

4. Add the Polygon Layer:

   • Add your polygon data into the ArcGIS visual, mapping it by the common identifier used to link with the points.
   • You may need to set it up as a Shape layer so that polygons will display when selected.

5. Enable Cross-Filtering:

   • Make sure cross-filtering is enabled between the point layer and the polygon layer.
   • When you select a point on the map, the interaction should filter the polygons layer to show only the polygon linked to that point.

6. Add Interactivity (Selection):

   • Configure the map visual’s interactivity options to allow for the selection of points.
   • When a point is selected, the polygon that corresponds to it will be displayed or highlighted.

7. Customize the Visualization:

   • You can further customize the map’s appearance, labels, tooltips, and layers based on your needs.

Notes:

• This workflow depends on both point and polygon data being structured with a common link (such as an ID or name).
• You can experiment with filters and slicers in Power BI to make the selection more interactive for the user.

Would you like more detailed steps on setting up ArcGIS in Power BI, or any help with a specific aspect of your dataset?

[tanharahman96]

Thank you, I will try this.

Would the latitude/longtitude data need to be in csv format for the points and in a shapefile format for the polygons?