how to kpi power bi?
APPLIES TO: Power BI Desktop Power BI service
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. For more about KPIs, see Key Performance Indicators (KPIs) in PowerPivot.
KPIs are a great choice:
A designer bases a KPI visual on a specific measure. 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.
A KPI dataset needs to contain goal values for a KPI. If your dataset doesn't contain goal values, you can create them by adding an Excel sheet with goals to your data model or PBIX file.
In this example, you'll create a KPI that measures the progress you've made toward a sales goal.
KPIs are also available on your mobile devices. It gives you the option to be always connected to your business's heartbeat.
If your KPI doesn't look like the one above, it may be because you didn't sort by FiscalMonth. KPIs don't have a sort option. You'll need to start again and sort by FiscalMonth before you convert your visualization to a KPI.
APPLIES TO: Power BI Desktop Power BI service
A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. For more about KPIs, see Key Performance Indicators (KPIs) in PowerPivot.
KPIs are a great choice:
A designer bases a KPI visual on a specific measure. 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.
A KPI dataset needs to contain goal values for a KPI. If your dataset doesn't contain goal values, you can create them by adding an Excel sheet with goals to your data model or PBIX file.
In this example, you'll create a KPI that measures the progress you've made toward a sales goal.
KPIs are also available on your mobile devices. It gives you the option to be always connected to your business's heartbeat.
If your KPI doesn't look like the one above, it may be because you didn't sort by FiscalMonth. KPIs don't have a sort option. You'll need to start again and sort by FiscalMonth before you convert your visualization to a KPI.
- From the Fields pane, select Sales > Total Units This Year.
- Add Time > FiscalMonth.
- In the upper-right corner of the visual, select the More options ellipsis (.) and select Sort axis > FiscalMonth.
- Select the ellipsis again and choose Sort axis > Sort ascending.
