Data interaction with Reference Layer ArcGIS PowerBI

Hi WanqiYao ,

Depending on the information you provided, your goal is to represent the number of responses for each section as bubbles on a map, which is a great way to visually communicate the density and distribution of the data.

However, the tooltips in the ArcGIS layer are used for display purposes and do not directly interact with Power BI's data model for filtering or aggregation. Here is a workaround to help you achieve similar results:

1. Ensure that the SECTION data in the ArcGIS reference layer is provided in a format that can be imported into Power BI (e.g., Excel, CSV). there needs to be a matching field in the Power BI data model that corresponds to the SECTION field in the ArcGIS layer.
2. Use Power BI's scatterplot or bubble chart feature to create visualisations. For more information about creating bubble charts, see the following documentation:
   Scatter, bubble, and dot plot charts in Power BI - Power BI | Microsoft Learn
3. While Power BI does not directly support interactive filtering based on ArcGIS tooltip fields, you can use a slicer or other visual to allow the user to select a specific section. This selection can then be reflected in ArcGIS maps and bubble charts to create an interactive experience.
4. For more detailed instructions on using ArcGIS maps in Power BI, see the official documentation:
   Create an ArcGIS map in Power BI - Power BI | Microsoft Learn

Remember, the key to integrating data from different sources is to have a common field or identifier to accurately relate the data.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.