Forum Discussion
Power BI KPI Matrix Displaying Zero Target Value
Hi I am new to posting, but hope someone will pickup and provide some guidance. I am using the PowerKPIMatrix 3.1.1. It works as expected except when I have a target value of ZERO. The cont...
Hi Anonymous
It seems KPI Status is calculated with a formula like DIVIDE([Current Value] - [Target Value], [Target Value]). So when a target value is zero, it returns the optional value blank as zero cannot be the divisor.
Maybe you can create a measure to calculate the result by your own and put this measure into a Matrix visual to display the difference percentages.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.