Drill down is a design element that allows the user viewing the dashboard to control the level of detail displayed in a dashboard item by clicking a specific data point on the dashboard item. For example, sales totals for the year can be drilled down to view specific sales totals by quarter and then further to show sales totals by month.
To configure drill-down functionality for a dashboard item:
-
Launch the dashboard designer. The designer can be launched in several ways:
-
The dashboard designer is automatically launched when the dashboard is first created.
-
From the Dashboard Gallery area, select the dashboard to design in the left pane then click the Design button in the Dashboard ribbon group.
-
From the Administration area, click Dashboards in the left pane and select the dashboard to design, then click the Design button in the Dashboard ribbon group.
-
From the dashboard Properties dialog box, click the Design button at the bottom of the dialog box.
The dashboard designer is opened in a new user interface.
-
-
Click the Data tab to display the Data ribbon.
-
Click Drill Down.
-
Ensure that more than one Argument is supplied for the data items. The argument data is used to drill down on the data, with the drill down moving from the top (most general) to the bottom (most detailed) of the arguments list. The dashboard item is initially displayed using the top-most argument.
For example, to show the number of units sold in a dashboard item by category that can be drilled down into specific products, configure the data item arguments with the category and product parameters, with the category (most general) parameter first.