Create and manage KPIs
APPLIES TO: SQL Server Analysis Services Azure Analysis Services Power BI Premium
This article 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.
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. 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
In the measure grid, right-click the measure that will serve as the Base measure (value), and then click Create KPI.
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.
In Define status thresholds, click and slide the low and high threshold values.
In Select icon style, click an image type.
Click on Descriptions, and then type descriptions for KPI, Value, Status, and Target.
You can use the Analyze in Excel feature to test your KPI. For more information, see Analyze in Excel.
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.
|UI section||Key command|
|KPI base measure||ALT+B|
|Define status thresholds||ALT+U|
|Select icon style||ALT+I|