Key Performance Indicator Dialog Box

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on

The Key Performance Indicator (KPI) dialog box appears when you right-click a measure and click Create KPI or click Create KPI in the PowerPivot tab of the Excel ribbon. In the context menu, Create KPI is available only for measures you created. In the ribbon, the Create KPI control is enabled only when a measure is selected in the Field List.

A KPI is based on a specific measure and is designed to help evaluate the current value, status, and trend of a metric.

The Key Performance Indicator dialog box contains a common property (KPI Base Measure Value) and two sections, KPI Status and Descriptions.

KPI Base Measure

The KPI base measure (value) is a read-only field that inherits the name of the base measure for the KPI you create. To change the name of a KPI, right-click the KPI parent node, and then click Rename. The Edit Measure dialog box opens, where you can change the name of the KPI.

KPI Status Tab

Define target value

Select Measure, and then select a measure from the list, or select Absolute Value, and then enter any number.

Define status thresholds

Specify the thresholds for the status of the KPI either by dragging the status controls on the status bar or by entering the specific numbers. By default, the threshold reads from small to large, where the first control represents the lower range and the second control represents the upper range. To reverse this scale to read from large to small, enter the larger value for the first control. This will switch the scale and allow you to define a KPI where lower is better.

To change the order of the color icons, click the color icons. For example, you can reverse the colors so that red is high and green is low.

Select icon style

To change the icon type, click an icon set from the selection. The icons above the status bar change as you hover over the different icon sets. To define greater granularity in the thresholds, select one of the sets of five icons.

Descriptions Tab

Enter descriptions for each of the KPI objects (nodes). When you hover over the objects in the Field List, the descriptions appear as tooltips. The tooltips also appear in third-party applications that have implemented support for the descriptions.

ALT Shortcuts

UI section

Key command

KPI base measure


KPI Status




Absolute value


Define status thresholds


Select icon style








See Also


Measure Settings Dialog Box (Standard Aggregation)


Create a Measure in a PivotTable or PivotChart

Take a Tour of the PowerPivot UI