topic Re: Always increasing is good in a Power KPI Matrix? in Custom Visuals Development Discussion

Always increasing is good in a Power KPI Matrix?

SatyaVaitla — Mon, 22 Jan 2018 08:49:05 GMT

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 decreasing is good or constant is good. For example, for sales increasing is good, for wastage reduction is goood, for constant temperature constant is good. How to confugure my KPIs based on this property in Power KPI Matrix?

Re: Always increasing is good in a Power KPI Matrix?

v-viig — Wed, 24 Jan 2018 11:52:33 GMT

Please take a look at this sample report to find out more.

This sample report is actually a step-by-step tutorial.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Always increasing is good in a Power KPI Matrix?

SatyaVaitla — Thu, 25 Jan 2018 05:20:26 GMT

I wnt trhough the sample but could not find where to map my Increasing is Bad (for my wastage) where the graph should show higher values in red and lower values in green. i.e if i exceed my target of 3% wastage, it should show red (where as for sales, if my actual value is more than target value, it should be green).

Please let me know where to map this field.

Re: Always increasing is good in a Power KPI Matrix?

v-viig — Thu, 25 Jan 2018 09:16:03 GMT

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

pbicvsupport@microsoft.com

Re: Always increasing is good in a Power KPI Matrix?

Chris99 — Wed, 14 Feb 2018 09:34:27 GMT

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

Re: Always increasing is good in a Power KPI Matrix?

HarisF — Tue, 09 Apr 2019 10:31:43 GMT

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

Re: Always increasing is good in a Power KPI Matrix?

v-evelk — Tue, 09 Apr 2019 11:45:20 GMT

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
pbicvsupport@microsoft.com

Re: Always increasing is good in a Power KPI Matrix?

Chris99 — Tue, 09 Apr 2019 12:29:02 GMT

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