topic Re: power kpi matrix in Custom Visuals Development Discussion

power kpi matrix

lburgess — Wed, 20 Dec 2017 22:28:11 GMT

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?

Re: power kpi matrix

v-viig — Thu, 21 Dec 2017 08:09:38 GMT

Hello @lburgess

We'll look into this issue.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: power kpi matrix

lburgess — Thu, 21 Dec 2017 19:40:54 GMT

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.

Re: power kpi matrix

v-viig — Fri, 22 Dec 2017 08:06:52 GMT

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

pbicvsupport@microsoft.com

Re: power kpi matrix

lburgess — Fri, 22 Dec 2017 14:08:40 GMT

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!

Re: power kpi matrix

v-viig — Mon, 25 Dec 2017 13:20:36 GMT

We'll discuss this issue internaly and get back soon.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: power kpi matrix

Anonymous — Wed, 27 Dec 2017 09:34:15 GMT

I have the same problem. For me, 0 is a valid value.
Thanks for support!

Re: power kpi matrix

v-viig — Thu, 28 Dec 2017 07:37:16 GMT

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

pbicvsupport@microsoft.com

Re: power kpi matrix

ryan-gerres — Tue, 02 Jan 2018 19:21:06 GMT

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?

Re: power kpi matrix

chiragbagga — Tue, 02 Jan 2018 19:32:30 GMT

Hi,

I have another issue with formatting. I have custom column colors for each Metric Name. However, when the page is filtered by various other visualizations, the formatting is mixed up.

below is the original as set:

and below is when the page is filtered by other visuals:

Please advise.

Thanks,
Chirag

Re: power kpi matrix

v-viig — Fri, 05 Jan 2018 11:59:17 GMT

@ryan-gerres This is known issue of Power BI platform that is under investigation.

I hope that Power BI Core team will resolve this issue soon.

@chiragbagga This is actually one of limitation of Power KPI Matrix since we bind formatting options to data-rows.

This is why some options might unset after we apply a filter or selection.

Our recommendation and current workaround is to apply a filter first. After that you should change formatting options of Power KPI Matrix.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: power kpi matrix

chiragbagga — Fri, 05 Jan 2018 14:07:55 GMT

@v-viig Thanks for your response. I've tried applying the filter and then formatting the way I want it. however when the filter is changed or cleared during use of the report, it replicates the same issue. Please advise as this is not how it should work. Secondly, is a fix being worked on for this? I wouldn't imagine a visual being made with the expectation that filters will not be used.

Your help is much appreciated. i was using another visual called KPI Ticker by MAQ software. For somereason afterupdating power BI, it lost its alignment making it useless for my purposes. I like the power kpi matrix visual and would appreciate if you can fix this issue.

Re: power kpi matrix

v-viig — Mon, 08 Jan 2018 10:00:48 GMT

We aren't able to fix this issue due to Power BI platform limitation.

We'll look into this issue deeper from platform's side to fix the issue.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: power kpi matrix

lburgess — Mon, 08 Jan 2018 14:06:40 GMT

I presume your comment rgarding being unble to fix this issue is with regard to the formatting issue. Any progress on the zero values issue?

Re: power kpi matrix

v-viig — Tue, 09 Jan 2018 08:44:21 GMT

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

pbicvsupport@microsoft.com

Re: power kpi matrix

lburgess — Tue, 09 Jan 2018 14:29:20 GMT

Perfect! Thanks!

Re: power kpi matrix

chiragbagga — Tue, 09 Jan 2018 14:35:39 GMT

@v-viig Please advise where can I has more insight to resolution of this issue. As this is an issue in the visual / platform which hinders its use. I would appreciate if I can somehow be informed of the progress. I would understand that there may be other issues being looked at with the platform. Is there a progress / update page/ link/ forum for this ?

Thanks

Re: power kpi matrix

v-viig — Wed, 10 Jan 2018 07:19:21 GMT

@chiragbagga We'll update this topic once we get any news about the issue.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: power kpi matrix

nerdalert1 — Thu, 18 Jan 2018 18:52:03 GMT

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.

Re: power kpi matrix

lburgess — Thu, 18 Jan 2018 19:52:58 GMT

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.