Forum Discussion
Power KPI Matrix - bypass KPI Indicator Value automatic calculation
Good afternoon,
I'm using the Power KPI Matrix visual to compare performance of KPIs versus to LY and 2 years ago (2LY). When comparing a percent metric, I'd like to put basis point change into the KPI Indicator Value and Second KPI Indicator Value fields, but as of now the KPI Indicator Value is being pre-calculated instead of using the field I provided.
Looking at the sample file, I understand it states that this value is pre-calculated. Is there a way to bypass that automatic calculation for the KPI Indicator Value, as is possible with the Second KPI Indicator Value?
Sample File:
from the documentation, looks like custom numbers can only be used in the second KPI indicator value. can this be bypassed for the first KPI Indicator Value?
Metric Example:
3 of the 4 metrics match, but the last one appears to be calculated and doesn't use my value. Is there a way to bypass the automatic calculation for KPI Indicator Value?
Appreciate your help,
-Andy
Hi Evgenii,
I am unable to send over the file itself, per the data it contains.
When trying to re-create the issue with the latest graphic version I am no longer getting this issue. It seems that updating the graphic and re-building the KPI Matrix from scratch was enough to resolve this issue.
Thank you for your help.
-Andy
9 Replies
Hello Andy,
If you use Row-Based data model you will just need fiil the bucket "KPI Indicator Value" by your column and values will be taken from it instead of automatically calculated.
If you use Column-Based data model you will need manually map necessery field throug "Edit" menu item as is said in the instruction from the sample report.
I see that the instruction in the sample report is little bit ugly regarding this moment (it is called "Variance" there) so we will update this info, thanks.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]Hi Evgenii,
thanks for the quick follow up. I'm using the "Column-Based" approach and had followed the "Edit" steps to map the columns prior to my original post, including clicking "apply". This is what the mapping looks like for my example. With this approach, I still end up with the pre-calculated difference (1966.1%) instead of the value I mapped (20, whole number).
same types of metrics are mapped for both KPI Indicator Value and Second KPI Indicator Value. However, formatting is still not working as expected.
Appreciate your insight,
-Andy
HI Andy,
It is strange, I will check.
If it is possible, please will send your report and dataset to [email protected] for analysis.
Kind Regards,
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
[email protected]
Hi Evgenii,
I am unable to send over the file itself, per the data it contains.
When trying to re-create the issue with the latest graphic version I am no longer getting this issue. It seems that updating the graphic and re-building the KPI Matrix from scratch was enough to resolve this issue.
Thank you for your help.
-Andy
