triadadragon.blogg.se - Tabular display

Tabular display how to#

Status Graphic: the group of graphical elements to display for Status.

Status Description: description of the Status.

The properties available for Status and Trend are: The graphic elements available are identical, so it is up to the data modeler to choose graphical element that better represent the concept of Status and Trend.

Tabular display how to#

However, both Status and Trend have the same set of properties to describe how to graphically represent the KPI status and trend. Status and Trend are similar attributes that differ in how they are consumed in the report. Target Format String: the format string used to present the Goal value for the KPI.

Target Expression: a DAX expression evaluated in the filter context of the KPI measure.Target Description: description of the Goal value of the KPI.Even though it is common to just reference another measure, the Target could be defined using any DAX expression. For example, the Target for Sales Amount could be the Budget Amount. When displayed in the user interface, it is used to define a reference value compared to the value of the KPI. The Target is just another measure that can be compared with the result of the expression assigned to the KPI measure. Therefore, we use Goal for the user interface, whereas we use Target to describe the corresponding properties in the Tabular model. Format String: how to display the result of the expression (only for Goal).Įven though the attributes shown to the user are called Status, Goal, and Trend, in Tabular these attributes are called Status, Target, and Trend, respectively.This string could be used by the client, even though it is not currently displayed by Power BI. Description: a string with the description of the meaning of the attribute.Expression: a DAX expression that defines the value of the attribute.Graphic: the graphical element to display for the attribute (only for Status and Trend).The Tabular model offers several properties for Status, Goal, and Trend attributes: Trend: a visual representation of how the measure is changing over time.īy using the KPIs you obtain reports like the following.

Goal: a value used to compare to the original measure, usually to determine the Status.

Status: visually describes the status of the measure.

This article describes in more detail all the KPI properties available, providing insights not available in the documentation.Įvery measure of a Tabular model can be transformed into a KPI, which has these additional attributes compared to a measure: You can find an introduction to KPIs in “ Creating KPIs in Power BI Desktop”. The Tabular model is common to Analysis Services, Power BI, and Power Pivot.