Forum Discussion
power kpi matrix
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
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
Re the second issue, yes. If the reported value is 0, that says that no progress has been made towards the KPI. I understand filtering out nulls, but 0 is a valid value. As it stands today, we are unable to use the visual because of this issue.
Thanks!
We'll discuss this issue internaly and get back soon.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
I have the same problem. For me, 0 is a valid value.
Thanks for support!Power KPI Matrix 2.1.0 is going to support zero values by enabling a special toggle at Actual group of format panel.
The release is expected in January.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals