Microsoft Power BI Cookbook

Dual KPI - headcount and labor expense

1. In Power BI Desktop, select the dual KPI custom visual to add it to the report canvas.
2. Apply a column of the date datatype to the Axis field well. A text column in the format 2017-Jan can also be used.
3. Drop the headcount and labor expenses measures into the top and bottom values field wells, respectively.
4. Apply a date column to the top and bottom percentage change start date field wells. A measure cannot be used.

In this example, the One Year Prior Date column created in the Getting ready section is used for both the top and bottom percentage change start date field wells. As this column only contains one value, it can be hidden from the Fields list after being added to the dual KPI. Although it's ...