Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lburgess
Helper II
Helper II

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
v-viig
Community Champion
Community Champion

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

View solution in original post

96 REPLIES 96
v-viig
Community Champion
Community Champion

Such behavior might happen if the data set contains more rows than Power KPI Matrix can handle and render.
We'd recommend reduce amount of data points by applying a proper filter.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

Hi @v-viig,

 

Thank you for prompt reply.

I do have only 251 records in the excel.

 

May i know whats the limit of records for the KPIMatrix.

 

Thanks,

Sujith.

v-viig
Community Champion
Community Champion

What is Y-axis Min, Y-axis Max and Use Common Scale for All Metrics and this particular metric?

You can find this options udner Format Panel -> Sparklines.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

Hi @v-viig,

 

I did that, but no luck 😞

 

Thanks,

Sujith.

v-viig
Community Champion
Community Champion

Can you share a pbix report to reproduce this issue on our end?

 

You can share via email: pbicvsupport@microsoft.com

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

Hi @v-viig,

 

I have sent the pbix file to recreate the issue.

 

Thanks,

Sujith.

v-viig
Community Champion
Community Champion

Thank you. I'll look into it.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

Hello @v-viig,

 

On Power BI Desktop.

 

Thanks,

Sujith.

v-viig
Community Champion
Community Champion

@Anonymous Can you share a pbix report to reproduce this issues from our end?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Does anybody know how to get Category and SubCategory columns to turn on?

v-viig
Community Champion
Community Champion

@seebert42 Please check this topic out.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

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.

pcraokjr
Frequent Visitor

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

 

pcraokjr
Frequent Visitor

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

nerdalert1
New Member

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.

v-viig
Community Champion
Community Champion

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

pbicvsupport@microsoft.com

So what will the visual display when the comparison value is 0?

ryan-gerres
Frequent Visitor

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?

v-viig
Community Champion
Community Champion

Hello @lburgess

 

We'll look into this issue.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors