Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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 .....
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
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
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.
You just need to include a filter for each area (Country, Region, etc.).
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
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.
Looks like Power BI summurize KPI Index.
Please use Maximum aggregation instead:
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
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?
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
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?
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
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).
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