Forum Discussion

lburgess's avatar
lburgess
Helper II
8 years ago
Solved

power kpi matrix

Not sure whether this is the correct location to post this, but here goes...   I downloaded the new Power KPI Matrix today. It provides the balanced scorecard reporting that I had been looking for....
  • v-viig's avatar
    v-viig
    8 years ago

    Power KPI Matrix supports zero values now by enabling a toggle at Actual Value group of Formatting Panel.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

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

Hello Anonymous,

 

Have you faced this issue in Power BI Desktop or Power BI Report Server?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-viig,

 

How do i attach pibx file. I do not see any option.

I have another issue with KPIMatrix.

In the below image there is data for four months from jan 2018 to Apr 2018.

However for some Products, i do not see the sparkline for afour months e.g CAT3 and PROD15.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But whenever i apply filter on CAT3, it shows four values in the sparkline for PROD15.

 

 

 

 

 

 

 

 

 

 

Not sure why it behaves that way.

Am I missing something here?

 

Thanks,

Sujith.

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

    Such behavior might happen if the data set contains more rows than Power KPI Matrix can handle and render.
    We'd recommend reduce amount of data points by applying a proper filter.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-viig,

       

      Thank you for prompt reply.

      I do have only 251 records in the excel.

       

      May i know whats the limit of records for the KPIMatrix.

       

      Thanks,

      Sujith.

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

        What is Y-axis Min, Y-axis Max and Use Common Scale for All Metrics and this particular metric?

        You can find this options udner Format Panel -> Sparklines.

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]