The requested page is not available for the requested platform. You are viewing the content for Default platform.

Drill-Down

  • 2 min to read

Dashboard provides the Drill-Down feature, which allows end-users to change the detail level of data displayed in a dashboard item. The Drill-Down feature enables users to drill down to display detail data, or drill up to view more general information.

Anim_Cards_DrillDown

Note

To learn how end-users can drill down using a particular dashboard item, see the Interactivity section for this item.

Enable Drill-Down

Drill-down requires that the data section contains several dimensions...

DrillDown_DataItems_SeveralDimensions

... or a hierarchy data item (in OLAP mode).

DrillDown_DataItems_Hierarchy

To enable drill-down, click the Drill-Down button in the Data Ribbon tab (or the DataShaping_Interactivity_DrillDown_Toolbar button if you are using the toolbar menu).

Chart_Interactivity_DrillDown_Ribbon

To enable drill-down in code, use the DashboardItemInteractivityOptions.IsDrillDownEnabled property. To access the DashboardItemInteractivityOptions object, use the dashboard item's InteractivityOptions property.

Note

If the selected dashboard item contains several types of elements that can be used for drill-down, the Ribbon or Toolbar will provide the appropriate buttons to switch between these types (e.g., Arguments and Series buttons in a Chart). For details, refer to the documentation for the individual dashboard items in the Designing Dashboard Items topic.

The following dashboard items support the Drill-Down feature.

Perform Drill-Down

The DashboardDesigner.GetAvailableDrillDownValues method allows you to obtain values that can be used to perform drill-down.

To perform drill-down/drill-up in code, use the DashboardDesigner.PerformDrillDown/DashboardDesigner.PerformDrillUp methods.

After drill-down (or drill-up) is performed in the Dashboard Designer, the DashboardDesigner.DrillDownPerformed (or DashboardDesigner.DrillUpPerformed) event is raised.

Interactivity_DrillDown_Common

You can use the DrillActionEventArgs.DrillDownLevel event parameter to determine the current drill-down level.

The DrillActionEventArgs.Values property allows you to obtain values from the current drill-down hierarchy.

Note

In OLAP mode, the DrillActionEventArgs.Values property returns unique names instead of values.

Examples

How to: Perform a Drill-Down in DashboardViewer

How to: Perform a Drill-Down in the ASP.NET Web Forms Dashboard Control

How to: Perform a Drill-Down in the ASP.NET MVC Dashboard Extension