I have a list with two columns. How can I add a KPI indicator for each new item created automatically? Where the value column is one, and the target column is the other?

Can I define the KPI list to do that? Is it possible using a workflow?

Thanks in advance.

4 Answers 4


Create a basic custom list with columns:

  • Value (type: Number)
  • Target (type: Number)
  • KPI (type: Calculated. Data type returned from this formula is: Number)

Formula for the calculated column is:

=IF(Value>Target,"<img src='/_layouts/images/KPIDefault-0.GIF'","<img src='/_layouts/images/KPIDefault-2.GIF'")

This will render a nice KPI icon in the KPI column.

(I'd recommend this simple solution because the SP KPI list has had sorting issues at least in SP2007/SP2010 and is a bit heavy if you only need to show a KPI icon based on two columns)


There are some good tutorials on creating KPI`s. You should be able to do the things you want with this.

Here is the first blog.

A blog by Rob Ashcroft.

Microsoft`s articles here and here.


If you are using a standard list then you can also do it with XSL - there is a post on creating a dashboard from a list on my blog which is similar to what you want to achieve.


Add below formula in calculated column field to show status indicator based on your column value

="<DIV style='font-weight:bold;  line-height:50%; align-center;font-size:36px; color:"&CHOOSE(LEFT([your column value],1),"gray","green","orange","red")&";'>•</DIV>"

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.