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

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

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?

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

        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

        [email protected]