Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |