Question on KPI


  • I have a calculated field in my powerpivot table.

    I want to add a KPI which acts as per following rules

    •  0 to 5% RED
    • 5 to 10% YELLOW
    • 10 to 20% Green
    • 20 to 40% Yellow
    • 40% to 100% RED

    How can I create such a KPI?

    I am trying this

    But the problem is that the middle peg... cannot be moved below 1. However as per my rule green should be between .2 and .4

    val it: unit=()

    Sunday, June 23, 2013 12:25 AM


  • You can change the absolute value target from 1 to .2 (or something within your middle range).  Then adjust the other thresholds as needed. 

    Seems like the thresholds don't automatically update when you change the target value, so you can switch the target type and then switch it back to get the thresholds to reset.  Should look like this.

    Let me know if that helps.

    Brent Greenwood, MS, MCITP, CBIP
    // Please mark correct answers and helpful posts //

    Sunday, June 23, 2013 4:26 PM