Forum Discussion

Amanda_Allen's avatar
Amanda_Allen
Frequent Visitor
6 years ago

Problem with POWER KPI MATRIX when actual value is 0

Good day   I am using Power KPI Matrix to display a summary of production data.  A recent problem has been encountered when one or more of our metrics is zero for the week it is not showing zero in...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Amanda_Allen , is ending on the current week. Because; if the value is blank, not 0 then visual might not show that week

Amanda_Allen's avatar
Amanda_Allen
Frequent Visitor
6 years ago

Hello amitchandak  I would expect this behaviour if the value was NULL, however it is listed in our systems as zero which is correct as the metric is measuring failures and this measure did not have any in Week 23.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Amanda_Allen ，

     

    Based on my test,if you the actual value is 0,the related rows in KPI matrix return null.See below:

    You can try to add category to separate the 0 or null values.

     

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello,

       

      I have the same issue. If target value is zero, then nothing is displayed in the cell and the KPI Status is blank. 

       

      Has anyone been able to find a solution to display 0 instead of blank?

       

      Could you please explain what do you mean by: "You can try to add category to separate the 0 or null values."?