KPI in Performancepoint Dashboards RRS feed

  • Question

  • Hello

    I want to create KPI based on calculated measure. I have created calculated measure as (Actual - Budget). Now, I want threshold based on this calculated measure.

    If Actual - budget =0 then green

    If Actual - budget >=1 then Yellow

    If Actual - Budget >=-1 then Red.

    Is it possible to create this threshold? I am not sure what to select for Scoring pattern.

    Thank you in advance.

    Tuesday, December 22, 2015 11:05 PM


  • Hi Swetha,

    According to your description, you want to use calculated values as threshold.

    Per my test, the thresholds display as percentage and the scoring pattern has 3 options: Closer to target is better, Increasing is better and Decreasing is better.

    From your description, “Closer to target is better” will be your choice.

    For more details, you can refer to the link below:


    Best regards,

    Aaren liu

    TechNet Community Support
    Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com.

    • Marked as answer by Victoria Xia Friday, January 8, 2016 3:01 AM
    Thursday, December 24, 2015 5:41 AM