Forum Discussion
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
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