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!