[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Collapse]Dashboard
 [Expand]Getting Started
 [Expand]Basic Concepts and Terminology
 [Expand]Common Features
 [Expand]Creating the Designer and Viewer Applications
 [Collapse]Creating Dashboards
  [Collapse]Creating Dashboards in the WinForms Designer
    Creating a Dashboard
   [Expand]Providing Data
    Adding Dashboard Items
   [Expand]Binding Dashboard Items to Data
   [Expand]Designing Dashboard Items
   [Expand]Data Shaping
   [Collapse]Interactivity
     Master Filtering
     Drill-Down
     Cascading Lookup using Master Filters
   [Expand]Appearance Customization
   [Expand]Data Analysis
    Converting Dashboard Items
   [Expand]Dashboard Layout
    Undo and Redo Operations
    Automatic and Manual Updates
    Saving a Dashboard
   [Expand]Printing and Exporting
  [Expand]Creating Dashboards on the Web
  [Expand]Creating Dashboards in the Visual Studio Designer
 [Expand]Visual Studio Integration
  End-User Documentation
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Video Tutorials
 [Expand]Migration Guides
 [Expand]Examples
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Drill-Down

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.

Expanded 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.

Expanded 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.

Expanded Examples

Is this topic helpful?​​​​​​​