Use the drill through feature

Note:

Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.

Use the Microsoft drill through feature to filter details from an ArcGIS for Power BI map report page to other report visualizations. See Layers, Data layers, and Reference layers to learn more about each type of layer.

Drill through is a Microsoft feature that you can use to filter map data details to the report context you specify. To use drill through, you must first establish drill through settings in ArcGIS for Power BI. You must also have added data to the visualization that can be shared with other Power BI report visualizations.

Tip:

You can use Power BI Desktop or the Power BI service (powerbi.com) with the drill through feature.

To use the drill through feature, complete the following steps:

  1. Add a data layer to an ArcGIS for Power BI visualization that includes other report visualizations and save the report.
  2. With the ArcGIS for Power BI visual active in Power BI, drag an attribute from the Data pane to the Drill through field well on the Visualizations > Build visual tab.

    Drill through field well with attributes

  3. Turn on the Cross-report toggle button to enable a contextual relationship between the map and other reports.

    When Cross-report is turned on, you can contextually move from one report to another in the same Power BI service or desktop instance. Use Cross-report to connect two or more reports with related content and improve filter context.

  4. Set the Summarized or Used as category filter options for a selected drill through attribute. When you add an attribute to the Drill through field well, you can set a filter for the attribute's data to be summarized or used as a category.
    • Summarized—Aggregate all data in the selected attribute. The map updates to show locations that contain any of the aggregate values.
    • Used as category—Choose a value from a list of attributes. The map updates to show only those locations that contain the chosen value.
    • Click the Lock button Lock to prevent other report users from editing the filter.
  5. Turn on the Keep all filters toggle button to apply the drill through attribute filters that you set in the previous step to all instances of those attributes in your other Power BI report pages.
    Note:

    Filtered drill through attributes from other pages of the report can be shown on the map when the Keep all filters toggle button is turned on. They are italicized and appear in the Drill through field well. See the Pass all filters in drillthrough section of the Set up drillthrough in Power BI reports Microsoft article for more information.