Forum Discussion
Advocate IIPeriodicity of KPIs in Power KPI Matrix
Power KPI Matrix calculates variance by Actaul and Comparison values of latest available date.
If you need to show month granularity, you have to aggegate data by months and use an instance of Power KPI Matrix for each date granularity.
Power KPI Matrix doesn't support Drill-down feature. The workaround is to create a Power KPI Matrix instance for level of hierarchy.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Community ChampionPower KPI Matrix is designed to support any date granularity.
You should design a report for each team or just apply a filter to filter useless teams out.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Advocate IIIt seems periodicity in the context of KPI is not known to technical people.
If my periodicity of Profit is Quarter, the comparison of target and Actual is only for the aggregation at quarter level. Even though my aggregated actual is more than the aggregate target value for two quarters, my dashboard will show green for one quarter and red for one quarter if i am not meeting my target for that quarter.
If i change my periodicity to month, again the my KPI achievement can be entirely different. It can be only two months green and 4 months red!
Also the answer of filtering out useless teams is not the answer. First of all, how can i know the useless teams from the KPI Matrix? Please let me know.
Also my teams and businesses are hiereachial in nature. An organisation can have departments, sub departments, line of businesses etc. If from one dataset i can not provide KPI matrix to all my users, we are talking about a personal KPI matrix with excel data maintained only for that person or business.
My question is how i can drill down from my organisation KPI matrix to my departmental KPI matrix. If the answer is still filter out the useless departments, i will take that as the solution (infact the whole purpose of KPI matrix is to anlyse more about these USELESS (if that is your right word) departments or teams becasue they are not performing. This is more important to red into green on future KPI matrix. If you dont see these red colors and anlyse the reasons, KPI matrix is not useful. Our KPI matrix alwasys shows green and we can always feel happy after filtering out Red.
My question is how to map the Periodicity and Business (or Team) structure in my KPI matrix. OR is it only meant for one individual?
- v-viig
Power KPI Matrix calculates variance by Actaul and Comparison values of latest available date.
If you need to show month granularity, you have to aggegate data by months and use an instance of Power KPI Matrix for each date granularity.
Power KPI Matrix doesn't support Drill-down feature. The workaround is to create a Power KPI Matrix instance for level of hierarchy.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals