Drill-Down
- 2 minutes 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.
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…
… or a hierarchy data item (in OLAP mode).
To enable drill-down, click the Drill-Down button in the Data Ribbon tab (or the button if you are using the toolbar menu).
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.
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