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 lburgess

 

We'll look into this issue.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

[email protected]

  • lburgess's avatar
    lburgess
    Helper II
    8 years ago

    I encountered another issue today.  If the data for the Current Value is 0, it uses the value from the prior period for the current period.  That means all of the comparisons, KPI values, etc are from the prior period, not the current period. I verified that by displaying the As Of Date.  All of the rows should be for Dec 2017.  The Funded (Units) "This Month" value, for example, for Dec 2017 is 0, yet the matrix shows the value for Nov 2017.

    I love this visual, but it seems a bit buggy.

     

     

     

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

      The first issue is related to some recent changes of Power BI platform.

      We're working in touch with Power BI Desktop team to address this issue.

      The current workaround is to publish the report to PBI web and apply formatting options manually one more time.

       

      The second issue is actually by design.

      It was the inital requirement to filter 0 and nulls (empty values).

       

      Does the second issue have high impact for your report?

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • lburgess's avatar
        lburgess
        Helper II
        8 years ago

        Re the second issue, yes.  If the reported value is 0, that says that no progress has been made towards the KPI.  I understand filtering out nulls, but 0 is a valid value. As it stands today, we are unable to use the visual because of this issue.

         

        Thanks!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi, 

       

      I'm relatively just a beginner in using this visualization tool and like your photo, I want to show Last Month's value on the table. Can you teach me to do that? 

       

      Thanks, 

      Van

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi, 

       

      I'm relatively just a beginner in using this visualization tool and like your photo, I want to show Last Month's value on the table. Can you teach me to do that? 

       

      Thanks, 

      Van

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Guys, 

         

        I'm just a new user of the Power KPI Matrix and I want to show Last Month's Value as Second Comparison Value but when I map the measure, it's not showing on the table. 

         

        The values are formatted as Percentages. Thanks for any help you may give. 

         

        Regards, 

        Van