power kpi matrix

[lburgess]

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?

[v-viig]

Hello @lburgess

We'll look into this issue.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[lburgess]

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.

 

[v-viig]

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

[lburgess]

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!

[v-viig]

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

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

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

[v-viig]

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

[chiragbagga]

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

[v-viig]

@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

[chiragbagga]

@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.

[v-viig]

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

[lburgess]

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?

[v-viig · Accepted solution]

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

[lburgess]

Perfect!  Thanks!

[Anonymous]

Hello,

Can we please get this feature of showing zero values for the Comparison Value and the Second Comparison Value?

Thank you for your time.

[v-viig]

Hello @Anonymous

We'll consider this feature in upcoming versions of Power KPI Matrix.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

@v-viig Thank you for your response. 

It causes some confusion with people because they believe data is missing. 

I tried doing a work around where I would place a value of .00001, but that also has its complications because the KPI Status will throw a huge figure in precentage increase.

Anyways, thank you for looking into this.

Joey

[v-viig]

Thank you for the details.

We'll implement zero-value support soon.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[BetterIdeaGroup]

I was looking to interate off the sample data but it's looking for a file not provided. Any chance to get that sample data uploaded rather than recreating?

It was looking for:

C:\Users\gregkoe\OneDrive - Microsoft\PBI\PowerKPIMatrix_SampleData.xlsx 

[v-viig]

Currenly we don't have the original data in excel format.

We'd recommend that you should export data from the sample pbix report.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[BetterIdeaGroup]

Thank you for your post, I did that for the operative table, I just wanted to post since I thought it would be useful to have it easily available so everyone didn't have to do that

[lburgess]

Still waiting on solution to the visual losing the custom formatting after it is published to the PBI service. Actually, something is causing that formatting to return to the default after an unknown period of time or an unknown event.  This could be a great visual but the formatting issue is a show-stopper to a significant degree.

[v-viig]

@lburgess This issue is on our backlog.

We'll investigate this issue deeper soon.

Current workaround is to reapply settings in Power BI Service after publication.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

Hello @v-viig,

Any update on this feature (visualizing zeros in "Target's" column for the Power KPI Matrix) coming up soon?

[v-viig]

Hello @Anonymous,

This feature is still on our backlog as we are focusing on other high priority tasks right now.

Hopefully, we'll start working on it soon.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[spfeifer]

Hello,

I am running the latest version of the Power KPI Matrix and I am not getting that option - but am having the same issue with zeroes not appearing in my matrix  Is this not the correct place to see the "treat zero as null" option, or is there some other issue happening?

Thanks!

.

[v-viig]

This option is available in Format Panel (the second tab):

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

Hi @v-viig,

We have been unable to add this visual to the organization visuals section in our tenant because of the message "Legacy visuals are not supported." Are there any plans to update this visual and the other Power KPI visual so that they can be used in organization visuals?

Thanks,

James

[v-viig]

Yes, it is on backlog but it also requires other related feature to be completed first.

We'll update once it's supported in Org Sctore scenario.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

Hello to everyone, any news with the format issues?

I am facing the same situation, in PBI Desktop I give the visual some formatting, column widths, etc., and then when I publish the report to the service I lose those formats.

Regards.

[v-viig]

No updates so far. It's still on our backlog.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

@v-viig is there any sort of timing (even a vague short-term vs long-term) that you provide about it being compatible with the Org Visuals? We really want to shut off the general marketplace (since we work in a heavily regulated industry) but this is a visual that we would like to provide to our users via the Org visuals.

[v-viig]

Power KPI Matrix will be avaialble in Org Store once we get some required APIs. Most likely it will be made next year.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

Thanks @v-viig

[jhaeusl1]

 Hi,

I see in my version of the Power KPI visual that the Current Value has an option that says "Treat zero values as nulls", when it is off the zeros display.  Is it possible to get this option added to the Comparison Value section?

[v-viig]

Hi @jhaeusl1,

We added this feature into our backlog but there's no ETA.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[Anonymous]

Hi

I am running version 

Name: Power KPI Matrix 3.1.1

Publisher: Microsoft

Id: powerKPIMatrixEB2381CC88A8425FBEB1B07FF57784E6

Version: 3.1.1

I am unable to see the toggle that you mentioned.  Is there an update I am missing?

Appreciate any help.

Thanks

Karen

[chiragbagga]

@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

[v-viig]

@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