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

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]

      • FraNat's avatar
        FraNat
        Frequent Visitor
        8 years ago

        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?