cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

KPI Matrix - Calc KPI Index issue

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.

13 REPLIES 13
Highlighted
Community Champion
Community Champion

Re: KPI Matrix - Calc KPI Index issue

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

Highlighted
Frequent Visitor

Re: KPI Matrix - Calc KPI Index issue

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.

Highlighted
Community Champion
Community Champion

Re: KPI Matrix - Calc KPI Index issue

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

Highlighted
Frequent Visitor

Re: KPI Matrix - Calc KPI Index issue

Screen1.jpgThat'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.

 

Highlighted
Community Champion
Community Champion

Re: KPI Matrix - Calc KPI Index issue

Looks like Power BI summurize KPI Index.

Please use Maximum aggregation instead:

 

Capture.PNG

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Highlighted
Frequent Visitor

Re: KPI Matrix - Calc KPI Index issue

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

Highlighted
Frequent Visitor

Re: KPI Matrix - Calc KPI Index issue

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?

Highlighted
Community Champion
Community Champion

Re: KPI Matrix - Calc KPI Index issue

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

Highlighted
Frequent Visitor

Re: KPI Matrix - Calc KPI Index issue

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?

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors