In this blog you will understand “How to use KPI visual in Power BI and How KPI % works?”.
The key Performance indicator (KPI) is a very good way to track your current value movement against defined Target.
The intention of the KPI is to help you evaluate the current value and status of a metric against a defined target.
A KPI visual requires a base measure that evaluates to a value, a target measure or value, and a threshold or goal.
Let’s get started-
Import below sample dataset into your Power BI Desktop
|Year||Actual Sales||Target Sales|
Following these steps-
Step-1: Add KPI visual into Power BI report canvas, and drag some columns-
Indicator: Actual Sales, Trend axis: Year, Target goals: Target Sales
Step-2: By default KPI displayed the current Sales & Target values. Explanation as below:-
- Current – Actual Sales: 2600000
- Target Sales: 2500000
- Target achieved by: +100000
- Green Color: Indicate Target achieved successfully, otherwise it will show the values in Red color.
- Percentage Formula: (Actual Sale – Target Sale) / Target Sale, then multiply by100.
Step-3: Now select any year from slicer-
For year-2018 Target not achieved, that’s why it is showing values as in Red color.
How to create a KPI % measure?
Create a measure with below DAX code-
KPI % = VAR ActualSale= SUM(Sales[Actual Sales]) VAR TargetSale= SUM(Sales[Target Sales]) VAR Diff = ActualSale - TargetSale RETURN DIVIDE(Diff, TargetSale)*100
Now add measure into Table visual, and see the KPI % result-
Formatting KPI visual-
General: Allows you to set X & Y-axis, width & height of column chart.
Indicator: Set display unit, font size, font family, horizontal & vertical alignment for Actual sales.
Trend axis: Enable/ Disable graph for KPI.
Goals: Provides below options-
- Goal: Enable/ Disable Target values.
- Label: Assign name for Target.
- Set Font color, font size & font family.
- Distance: Display difference of Target & sales. Also you can select value & percentage from Label dropdown.
- Distance direction: Manage Increase/ Decrease direction for positive.
Color coding: Set color for Good, Neutral & Bad.
Date: Set font size, text & color for date.
Title: Specified the Title name for KPI.
Refer more Power BI visuals- Power BI Visuals
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.