What's the meaning of "KPI status" in PowerKPI matrix EB?

[VivianX]

Hi all,

I downloaded PowerKPI matrix EB visulaization. When I click "Sparklines" chart, i shows something as below. Does anyone know what the meaning of "KPI status" an "Second KPI status"?

Very appreicate your input.

[AnalystPower]

KPI is a Key Performance Indicator. Do you have more than one measurable?

[VivianX]

I want to know what's the formula for "KPI status"...

[v-lili6-msft · Accepted solution]

hi, @VivianX 

For "KPI status", it will return the value of KPI Indicator Value, and if there is no filed or measure on it. It will calculate the Variance between Active value and Comparision Value automatically.

And for "Second KPI status", it will return the value of Second KPI Indicator Value, and if there is no filed or measure on it. It will calculate the Variance between Active Value and Second Comparision Value automatically.

And here is a sample data with instructions, please try it.

https://appsource.microsoft.com/en-us/product/office/WA104381299?src=office&corrid=e54374fe-cfe3-442...

Best Regards,

Lin

[VivianX]

Hi Lin,

I really appreciate your guidance.

Within your comment, one thing I do want to clarify that is , you mentioned"Active value ", do you mean "Actual Value" instead of "Active value"? Below is the screenshot of your sample file. Thank you!

[v-lili6-msft]

hi, @VivianX 

Yes, it is mean "Actual Value"

If there are multiple fields, please refer to this:

Best Regards,

Lin

[VivianX]

Thank you Lin, very thorough explaination! @v-lili6-msft 

[VivianX]

Hi @AnalystPower 

I dont know how this visulization calculates "KPI status"? Like the red circle number in my chart. Thank you!