cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lburgess Regular Visitor
Regular Visitor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-viig
Moderator

Re: 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

pbicvsupport@microsoft.com

92 REPLIES 92
Moderator v-viig
Moderator

Re: power kpi matrix

Hello @lburgess

 

We'll look into this issue.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

lburgess Regular Visitor
Regular Visitor

Re: power kpi matrix

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.

 

 

Capture.PNG 

Moderator v-viig
Moderator

Re: power kpi matrix

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 Regular Visitor
Regular Visitor

Re: power kpi matrix

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!

Moderator v-viig
Moderator

Re: power kpi matrix

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

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

numbersei Frequent Visitor
Frequent Visitor

Re: power kpi matrix

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

Moderator v-viig
Moderator

Re: power kpi matrix

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

ryan-gerres Frequent Visitor
Frequent Visitor

Re: power kpi matrix

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?

chiragbagga Frequent Visitor
Frequent Visitor

Re: power kpi matrix

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:

1.PNG

 

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

 

2.PNG

 

Please advise.

 

Thanks,
Chirag