Data interaction with Reference Layer ArcGIS PowerBI

[WanqiYao]

Hi all,

I have added an established ArcGIS map layer into PowerBI as a reference layer, in which its tool tips has two fields I'm interested to be filtered by the input data. For example my data has a list of Sections (numbers) and the Tooltip of the reference layer has a field SECTION which I want to use to create a bubble to indicate the number of respones from each section. Is there any way to do this at all?

Thank you so much for the time and help!

[Anonymous · Accepted solution]

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.