PowerPivot Nuggets - Part 10 - KPIs

KPIs are another Analysis Services concept coming to PowerPivot. Creating KPIs is pretty straight forward.

In the example below I have table with Sales and Costs. Let's say we want to have a 5% margin.

KPIs in PowerPivot are based on a meusure. So, first thing to do is create a measure to calculate the margin.


Step 2 is setting the KPI target values. Target values can again be based on a measure or as in this simple example on a fixed value.


Step 3 is setting the tresholds and finally we choose an icon style.

And that's it, our KPI is ready to use!