Forum Discussion
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...
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.
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!
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."?