Forum Discussion
power kpi matrix
Please go through Power KPI Matrix sample report to understand how this custom visual works.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Please go through Power KPI Matrix sample report to understand how this custom visual works.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi Ignat,
I have downloaded your linked file. When I click "Sparklines" chart, i shows something as below. Do you know what the meaning of "KPI status" an "Second KPI status"?
Below is the one example from me. Thank you a lot!
Hi,
"KPI Status" shows difference between actual and comparison values."Second KPI Status" shows difference between actual and second compariosn values.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]Hi,
Thank you for your reply v-evelk .
You are correct. But one thing I want to add more detail:
"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 Actual 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 Actual Value and Second Comparision Value automatically."
Hope this will be beneficial for other users.
v-viig WOW Amazing!
How didyou do for building the fact and dim table? I mean if I understood wel it is a fact KPI table where you have different types of KPI in different format linked to a DIM KPI table? I have a star schema and I would realy like to build such a schema for KPI reporting,
Thx a lot,
J.
