https://community.fabric.microsoft.com/t5/Developer/KPI-Status-Calculation/m-p/2494409#M35904 <P>Hello,&nbsp; I am using the KPI Power Matrix visual.&nbsp; How is the KPI Status column calculated?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TomSinAA_0-1651701626557.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/709349i2F49DFC4F7898D36/image-size/medium?v=v2&amp;px=400" role="button" title="TomSinAA_0-1651701626557.png" alt="TomSinAA_0-1651701626557.png" /></span></P><P>In the screen shot, KPI Status = +11% but the difference between the Completion % (actual KPI value) and target is 10%. No 11%.&nbsp; See additional screen shots for other values</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TomSinAA_1-1651701731733.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/709350i7E0BFD3C53DB3EFC/image-size/medium?v=v2&amp;px=400" role="button" title="TomSinAA_1-1651701731733.png" alt="TomSinAA_1-1651701731733.png" /></span></P><P>Thanks</P> Wed, 04 May 2022 22:03:50 GMT TomSinAA 2022-05-04T22:03:50Z https://community.fabric.microsoft.com/t5/Developer/KPI-Status-Calculation/m-p/2494409#M35904 <P>Hello,&nbsp; I am using the KPI Power Matrix visual.&nbsp; How is the KPI Status column calculated?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TomSinAA_0-1651701626557.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/709349i2F49DFC4F7898D36/image-size/medium?v=v2&amp;px=400" role="button" title="TomSinAA_0-1651701626557.png" alt="TomSinAA_0-1651701626557.png" /></span></P><P>In the screen shot, KPI Status = +11% but the difference between the Completion % (actual KPI value) and target is 10%. No 11%.&nbsp; See additional screen shots for other values</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="TomSinAA_1-1651701731733.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/709350i7E0BFD3C53DB3EFC/image-size/medium?v=v2&amp;px=400" role="button" title="TomSinAA_1-1651701731733.png" alt="TomSinAA_1-1651701731733.png" /></span></P><P>Thanks</P> Wed, 04 May 2022 22:03:50 GMT https://community.fabric.microsoft.com/t5/Developer/KPI-Status-Calculation/m-p/2494409#M35904 TomSinAA 2022-05-04T22:03:50Z https://community.fabric.microsoft.com/t5/Developer/KPI-Status-Calculation/m-p/2501019#M35964 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/97046">@TomSinAA</a>&nbsp;,</P> <P>&nbsp;</P> <P>I think Power KPI Matrix will calculate KPI Status by values in [Actual Value] and [Comparison Value]. This is based on your data model. You may refer to this sample file from creator to learn more details.</P> <P>For reference:</P> <P><A href="https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381299?tab=overview" target="_self">Power KPI Matrix</A></P> <P>&nbsp;</P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Mon, 09 May 2022 06:34:12 GMT https://community.fabric.microsoft.com/t5/Developer/KPI-Status-Calculation/m-p/2501019#M35964 Anonymous 2022-05-09T06:34:12Z