topic Re: Power KPI Matrix Setting Targets in Custom Visuals Development Discussion

Power KPI Matrix Setting Targets

Anonymous — Tue, 16 Apr 2019 16:57:58 GMT

How do I create these targets in the right format for the Matrix?

I'm trying to use the KPI Matrix (imported from marketplace) and looked through this tutorial .

I've gotten my matrix to look like this, I need help with KPI Status and Comparison Values.

1. Comparison Values

Some of the targets I sent are static numbers and some are dynamic.
Example:
Metric - Cycle Time

Comparison Value - 55 days (static)

Metric - Number of Completions

Comparison Value - Change from previous month (dynamic)

2. KPI Status

From what I've seen this is a mix of KPI Indicator Index and Indicator Value -- how do I manipulate my data or construct a table or measure to correctly show these?

Any help very appreciated!

Re: Power KPI Matrix Setting Targets

v-evelk — Wed, 17 Apr 2019 14:10:12 GMT

Hello,

First of all it is necessery to clarify what type of data format you use Row-based or Column-based.

Also you can switch matrix from marketplace into table format and you will see how data is structurized.

For KPI Status visualization matrix uses field from "KPI Indicator Index" bucket but you need calculate that index for your data regarding your own criteria comparing actual data and comparison data in a row.

For instance, you have actual data in a row as 8 and your target data is 10, let's suppose that it is 80% of target and you can suppose that is is a good result and bind it to index 1, but for actual value 6-8 you can suppose that it is average result and bind it to index 2, 5 and lower is bad and bind it to index 3. Finally you wil get something like the following:

Actual	Target	KPI_Index
8	10	1
6	10	2
4	10	3

Then you need set up colors and icons for corresponding indx only in the format panel.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Re: Power KPI Matrix Setting Targets

Anonymous — Fri, 19 Apr 2019 16:42:04 GMT

@v-evelkThank you, that is helpful!

Another question about the matrix custimization, is it possible to add an indicator color in the Second Comparison?
It doesn't seem to be an option...

Re: Power KPI Matrix Setting Targets

v-evelk — Mon, 22 Apr 2019 15:32:33 GMT

No, it is impossible and we aren't sure that it has a sense.

If you suppose that it is a valuable option you can create an idea here and if it gets a lot of votes we will consider to add this feature in the next releases.

Kind Regards,

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com