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...
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

    • FraNat's avatar
      FraNat
      Frequent Visitor
      8 years ago

      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?

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

        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

        [email protected]