Forum Discussion

SatyaVaitla's avatar
SatyaVaitla
Advocate II
8 years ago
Solved

Always increasing is good in a Power KPI Matrix?

in the sample, i see always increasing is good ( if actual value is more than target value the color is green ). But one of the KPI property in any scorecard is whether the increasing is good or decr...
  • v-viig's avatar
    v-viig
    8 years ago

    You should calculate KPI Index for such values.

    Please visit KPI Indicator Instructions page of the sample report to fint out how to generate a KPI index properly.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

  • Chris99's avatar
    Chris99
    8 years ago

    For the KPI Indicator visual click on the Format tab (the paint roller), and then in KPI General look at the options for Banding Type. The three choices are Increasing is better, Decreasing is better, and Closer is better. You want the middle option by the sounds of it.

     

    Chris

Chris99's avatar
Chris99
Advocate III
8 years ago

For the KPI Indicator visual click on the Format tab (the paint roller), and then in KPI General look at the options for Banding Type. The three choices are Increasing is better, Decreasing is better, and Closer is better. You want the middle option by the sounds of it.

 

Chris

HarisF's avatar
HarisF
Regular Visitor
7 years ago

Hi, I couldn't find these options under KPI Indicator nor KPI Indicator Value. Are we talking about the same Power KPI Matrix visual?

Chris99 wrote:

For the KPI Indicator visual click on the Format tab (the paint roller), and then in KPI General look at the options for Banding Type. The three choices are Increasing is better, Decreasing is better, and Closer is better. You want the middle option by the sounds of it.

 

Chris

 

  • Chris99's avatar
    Chris99
    Advocate III
    7 years ago

    HarisF  Apologies, it must have been one of the custom KPI visuals we were trying at the time. For the standard KPI visual look in Color Coding. There is a Direction (eg "Low is good" or "High is good"), and you can set three colours which are used based on your Goals settings.

     

    Hope this helps,

     

    Chris

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    Hi,

     

    You will not find because Power KPI matrix use KPI Indicator Index to detect indicator for a metric.

    I am not sure what visual Chris meant.

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]