Forum Discussion
PowerKPI Matrix Sparkline
Many thanks for taking the time to reply. I have found a way to do what I want.
In my dashboard I have some KPIs where the "actual value" below a target is good e.g. we want fewer complaints than our target. And some where "actual value" above target is good. e.g. sales. In the KPI Matrix sample file the variance from target is calucated and a RAG status given depending on the parameters you set. I didn't know if there was something built into the template that indicated whether, for individual KPIs, above or below target should be Red/Green. And I still don't know that. But what I did was added a column which indicated the "direction" of the target. I just labelled each KPI as either Low or High. And then when it is Low I'm multiplying the variance by -1. That works so that my RAG status labels are all correct.
Apologies if anyone was going to reply, I've persevered and fixed my sparkline issues. But I have one problem left. Using the sample pbix that is published with the PowerKPI Matrix, I don't understand how the Calc Variance and KPI Indicator determine whether the relationship between "actual value" and "comparitor" (in my case the KPI target) is good or bad. i.e where I have 2 KPIs, for the first (e.g. sales) value above target is good, for the second (e.g. Returns) value below target is good. But the variance and indicator for all KPIs are taken from a single column. Grateful for any help.
Hi mmurchie
In the sample file of the PowerKPI Matrix, I see only one KPI status in the matrix. And it only has one target column and one actual value column in the data table. Do you mean you want to have two KPI status, one for sales and the other for returns? What do you mean by "But the variance and indicator for all KPIs are taken from a single column"?
Regards,
Community Support Team _ Jing
Many thanks for taking the time to reply. I have found a way to do what I want.
In my dashboard I have some KPIs where the "actual value" below a target is good e.g. we want fewer complaints than our target. And some where "actual value" above target is good. e.g. sales. In the KPI Matrix sample file the variance from target is calucated and a RAG status given depending on the parameters you set. I didn't know if there was something built into the template that indicated whether, for individual KPIs, above or below target should be Red/Green. And I still don't know that. But what I did was added a column which indicated the "direction" of the target. I just labelled each KPI as either Low or High. And then when it is Low I'm multiplying the variance by -1. That works so that my RAG status labels are all correct.
That's a clever solution. I never thought of that. Thank you for enlightening me.