Forum Discussion

FraNat's avatar
FraNat
Frequent Visitor
8 years ago

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 wor...
FraNat's avatar
FraNat
Frequent Visitor
8 years ago

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.

v-viig's avatar
v-viig
Community Champion
8 years ago

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

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

  • FraNat's avatar
    FraNat
    Frequent Visitor
    8 years ago

    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.

     

    • v-viig's avatar
      v-viig
      Community Champion
      8 years ago

      Looks like Power BI summurize KPI Index.

      Please use Maximum aggregation instead:

       

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • FraNat's avatar
        FraNat
        Frequent Visitor
        8 years ago

        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