Forum Discussion
power kpi matrix
Not sure whether this is the correct location to post this, but here goes...
I downloaded the new Power KPI Matrix today. It provides the balanced scorecard reporting that I had been looking for. I got it all configured and customized in Power BI Desktop, then published the report to the Power BI service. All of the customizations I had done to format Current Value and set colors for the Sparkline charts were lost. I had to re-do them in the Power BI service and save them there.
Is anyone else experiencing this issue?
Power KPI Matrix supports zero values now by enabling a toggle at Actual Value group of Formatting Panel.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
96 Replies
Hello lburgess
We'll look into this issue.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I encountered another issue today. If the data for the Current Value is 0, it uses the value from the prior period for the current period. That means all of the comparisons, KPI values, etc are from the prior period, not the current period. I verified that by displaying the As Of Date. All of the rows should be for Dec 2017. The Funded (Units) "This Month" value, for example, for Dec 2017 is 0, yet the matrix shows the value for Nov 2017.
I love this visual, but it seems a bit buggy.The first issue is related to some recent changes of Power BI platform.
We're working in touch with Power BI Desktop team to address this issue.
The current workaround is to publish the report to PBI web and apply formatting options manually one more time.
The second issue is actually by design.
It was the inital requirement to filter 0 and nulls (empty values).
Does the second issue have high impact for your report?
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I am having the same issues with the formatting being dropped when published to the web service. Is there a timeframe on the next release for the visual?
Thanks for adding the ability to treat zeros as values. I'm now able to enable that for my actuals, but it's still not working for the comparison value. Zero is a legitimate value for a comparison as well. Am I missing this, or is it possible to add in a future release?
Thank you.
Excellent point! I had missed that there was no option to not treat zero as null for the comparison value or second comparision value. To me, there should be the option to treat zero as a valid value for all values. Otherwise, the visualization is essentially useless for me.
Zero values are not supported for Comparison values since the varaince will be NaN (current value / comparison value).
This is the main reason why we implemented Zero values only for Current/Actual values.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi
I'm using Power KPI Matrix latest version PowerKPIMatrix.2.1.1.0.pbiviz, but unfortunately its not displaying the KPI Indicators icon which set as part of KPI Indicator formatting menu. Is anyone faced similar issue to display KPI Indicators icons. if so Please provide solution.
Thanks
Hi
I'm using Power KPI Matrix latest version PowerKPIMatrix.2.1.1.0.pbiviz, but unfortunately its not displaying the KPI Indicators icon which set as part of KPI Indicator formatting menu. Is anyone faced similar issue to display KPI Indicators icons. if so Please provide solution.
Thanks
Hello,
I always end up with this issue when building something on PowerKPIMatrix.
The KPI status column wont show up the symbols at all.
If I use the sample file from the Appsource and build the matrix with same data, I get the Status Symbols.
But not in the new file.
Am i missing something to install here?
Thanks,
Sujith.
Hello Anonymous,
Have you faced this issue in Power BI Desktop or Power BI Report Server?
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi Anonymous ,
Though the "Icons color" does not display by itself, there is an alternative solution for the same.
You can try the solution mentioned in this link:
https://community.powerbi.com/t5/Desktop/KPI-STATUS-in-POWER-KPI-MATRIX/m-p/720784
I found it useful as it worked for my Data Tables.
Hoping that it will be useful for you as well.
Thank you,
Susmitha
Thanks for this great visual, it works pretty well for me.
Only one thing is a bit annoying. It always shows the data for the last value of the selected date field. In the Actual and Comparison values I would like to show an average for the selected dates (which is exactly what my underlying measure calculates), but this is not working now because it now only takes the "average" for the last date.
Could you consider adding the option to show the "total" for the selected date fields instead of only the last one?
Or provide an option to use a different field in the spark line than the one in Date, that would be even better perhaps.
fbeekvel Thanks for the feedback. An ability to use another data field for sparkline has been added to the backlog (#26424).
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
HI Guys
Please help me... i have been struggling the whole day with this formula.
How do i change the hilighted formula (Red) to give a percentage of row total.
My current formula is giving the sum of selected Level5 for the selected Month.
Current formula answer = 2 (hilighted Orange)
Requested formula = 2 (hilighted Orange) / 5 (hilighted Blue)
Kind regards
Nocha
Hi Mvumelwano,
We'd recommend to ask this question in this thread instead.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
