Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
Best Regards,
Lin
KPI is a Key Performance Indicator. Do you have more than one measurable?
I want to know what's the formula for "KPI status"...
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.
Best Regards,
Lin
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!
hi, @VivianX
Yes, it is mean "Actual Value"
If there are multiple fields, please refer to this:
Best Regards,
Lin
I dont know how this visulization calculates "KPI status"? Like the red circle number in my chart. Thank you!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |