Create and Manage KPIs (SSAS Tabular)

This topic describes how to create, edit, or delete a KPI (Key Performance Indicator) in a tabular model. To create a KPI, you select a measure that evaluates to the KPI’s Base value. You then use the Key Performance Indicator dialog box to select a second measure or an absolute value that evaluates to a target value. You can then define status thresholds that measure the performance between the Base and Target measures.

This topic includes the following tasks:

Tasks

Important

Before creating a KPI, you must first create a Base measure that evaluates to value. You then extend the Base measure to a KPI. How to create measures are described in another topic, Create and Manage Measures (SSAS Tabular). A KPI also requires a target value. This value can be from another pre-defined measure or an absolute value. Once you have extended a Base measure to a KPI, you can then select the target value and define status thresholds in the Key Performance Indicator dialog box.

To create a KPI

  1. In the measure grid, right-click the measure that will serve as the Base measure (value), and then click Create KPI.

  2. In the Key Performance Indicator dialog box, in Define target value, select from one of the following:

    Select Measure, and then select a target measure from the listbox.

    Select Absolute value, and then type a numerical value.

  3. In Define status thresholds, click and slide the low and high threshold values.

  4. In Select icon style, click an image type.

  5. Click on Descriptions, and then type descriptions for KPI, Value, Status, and Target.

Tip

You can use the Analyze in Excel feature to test your KPI. For more information, see Analyze in Excel (SSAS Tabular).

To edit a KPI

  • In the measure grid, right-click the measure that serves as the Base measure (value) of the KPI, and then click Edit KPI Settings.

To delete a KPI and the base measure

  • In the measure grid, right-click the measure that serves as the Base measure (value) of the KPI, and then click Delete.

To delete a KPI, but keep the base measure

  • In the measure grid, right-click the measure that serves as the Base measure (value) of the KPI, and then click Delete KPI.

ALT Shortcuts

UI section Key command
KPI base measure ALT+B
KPI Status ALT+S
Measure ALT+M
Absolute value ALT+A
Define status thresholds ALT+U
Select icon style ALT+I
Trend ALT+T
Descriptions ALT+D
Trend ALT+T

See Also

KPIs (SSAS Tabular)
Measures (SSAS Tabular)
Create and Manage Measures (SSAS Tabular)