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
Anonymous
Not applicable

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

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
Not applicable

@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

power kpi matrix.png

Anonymous
Not applicable

Hello @v-viig,

 

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

v-viig
Community Champion
Community Champion

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

v-viig
Community Champion
Community Champion

Thank you for the details.

We'll implement zero-value support soon.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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 

 

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

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

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

@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

Perfect!  Thanks!

v-viig
Community Champion
Community Champion

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

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

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