topic Re: KPI Matrix - Calc KPI Index issue in Custom Visuals Development Discussion

KPI Matrix - Calc KPI Index issue

FraNat — Mon, 22 Jan 2018 14:53:39 GMT

In the example file of Power KPI Matrix it is possible to filter the visual by Country, but if I want to see, for instance, both France and Germany together then the KPI Indicator Status does not work anymore (it just sums the Calc KPI Index values instead of calculating them again).
How can I solve this problem with this Custom Visual (I'm using the Row_Based_Metrics)? Is it possible to modify the Calc KPI Index formula so it calculates it again when I want to see the KPI for the whole company instead of only one country?
Thanks in advance for your support.

Re: KPI Matrix - Calc KPI Index issue

v-viig — Tue, 23 Jan 2018 10:03:25 GMT

If you would compare countries we would recommend that you should add a Power KPI Matrix for each country.

Please let us know if that meets your requirements.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: KPI Matrix - Calc KPI Index issue

FraNat — Thu, 25 Jan 2018 07:58:13 GMT

Good day,
Actually it does not meet my requirements.
My organization is divided in geographical areas (Europe, America, Asia, etc), and each area has lots of countries in it. The goal is to have one visual with all the KPIs and the possibility to see them for the whole organization, for a single area or for a single country (using filters). This is actually possible with this Visual, the only thing that does not work is the KPI Indicator Status.
Is there a way to fix it?
Thanks in advance for your reply.

Re: KPI Matrix - Calc KPI Index issue

v-viig — Thu, 25 Jan 2018 09:20:41 GMT

You just need to include a filter for each area (Country, Region, etc.).

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: KPI Matrix - Calc KPI Index issue

FraNat — Thu, 25 Jan 2018 11:30:05 GMT

That's what I did, but if i select more than one country (or a whore area) then the KPI Indicator Status does not work anymore, as you can see in the attached screenshot.

Re: KPI Matrix - Calc KPI Index issue

v-viig — Fri, 26 Jan 2018 08:10:11 GMT

Looks like Power BI summurize KPI Index.

Please use Maximum aggregation instead:

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: KPI Matrix - Calc KPI Index issue

FraNat — Fri, 26 Jan 2018 08:15:59 GMT

Well, this is not the right solution, you cannot just select the index with the highest value.
In this way none of the KPI will give the correct result

Re: KPI Matrix - Calc KPI Index issue

FraNat — Tue, 30 Jan 2018 07:28:46 GMT

Actually I can not use this method. If I do so, then if only one country does achieve its KPI and all the others do not, then it seems that the whole organization is going well.
Is there another way to solve my issue?

Re: KPI Matrix - Calc KPI Index issue

v-viig — Tue, 30 Jan 2018 11:08:14 GMT

Another alternative is to prepare a couple of instances of Power KPI Matrix in order not to use filtering.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: KPI Matrix - Calc KPI Index issue

FraNat — Thu, 01 Feb 2018 08:24:39 GMT

Mh, sorry, i don't understand what do you mean with that.. Could you please make an example using the data in the sample file?

Re: KPI Matrix - Calc KPI Index issue

v-viig — Fri, 02 Feb 2018 07:29:45 GMT

I mean you need to add Power KPI Matrix for each country that you want to analyze.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: KPI Matrix - Calc KPI Index issue

FraNat — Fri, 02 Feb 2018 07:59:53 GMT

Well, I can already analyze every single country with a single Power KPI Matrix, the problem is that I cannot analyze a group of countries (e.g. Europe).

Re: KPI Matrix - Calc KPI Index issue

rexii23 — Mon, 05 Feb 2018 04:09:39 GMT

This is not completely related to the KPI visual but I have experienced the same issue with some of my metrics in other standard visuals such as tables.

It all depends on what you want the result to be when you add in aggregation. For this instance, I gather you want to sum the countries first for each metric and then do the actual calculation such work out variance to target. So it is sum then divide. The default behaviour could be divide then sum.

To solve this, I had to write a custom dax formula to ensure the calculation is correct. I can find the example right now but from memory it involves SUMX(FILTER(VALUES .....

Re: KPI Matrix - Calc KPI Index issue

v-viig — Mon, 05 Feb 2018 07:41:16 GMT

As a quick workaround you might put the country column into Hyperlink data-field.

Such workaround forces Power BI to stop summarize KPI Index.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com