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.
So let’s start with an example, sample dataset format as below:
|Year||Actual Sales||Target Sales|
Step-1: Now drag KPI visual to report page > “Actual Sales” to Indicator, “Year” to Trend axis & “Target Sales” to Target goals section.
Understand why it is showing 2600000 & Goal: 2500000 as in default?
By default KPI displayed the current Sale & 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 by 100.
Step-2: Now select any year from slicer & see the KPIs output.
For year 2015 target not completed that’s why it is showing values as in Red color.
How to create a KPI % measure?
KPI % = Var ActualSale= Sum(KPIData[Actual Sales]) Var TargetSale= Sum(KPIData[Target Sales]) Var diff = ActualSale - TargetSale Return DIVIDE(diff, TargetSale)*100
Now drag measure to Table visual.
Want to know about other visuals, refer this: Power BI Visualizations
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.