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

Power KPI Matrix: Am I doing something wrong? Line is blank when it shouldn´t be

Good evening,

 

I've been trying out the Power KPI matrix to compare sales estimates vs budget and previous year. The problem arises when for a given channel, the estimate (see attached screenshot- column "resultado actual") is blank. This renders the whole line blank, when it should display values for the budget and previous year columns. (I've applied a filter on "sales rep" btw)

Power KPI Matrix error.JPG

 

 Power KPI Matrix error.JPG

 

 

 

 

 

Is there something I'm missing?

 

Thanks in advance for your help.

 

Regards,

Paul





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






3 ACCEPTED SOLUTIONS
v-viig
Community Champion
Community Champion

Hello @PaulDBrown,

 

Power KPI Matrix doesn't render any values if Actual Value is not a valid value (empty or null).

Please specify a valid not zero value for Actual Value to fix this issue.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

View solution in original post

We're going to release Power KPI Matrix 2.1.0 next week that supports zero values.

Once this version is released you might try to set null value to zero to render the column.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

View solution in original post

Power KPI Matrix 2.1.0 has already been released.

Zero values can be turned on in Actual Value group of formatting panel.

 

Please let me know if this feature meets your initial requirements.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

View solution in original post

12 REPLIES 12
v-viig
Community Champion
Community Champion

Hello @PaulDBrown,

 

Power KPI Matrix doesn't render any values if Actual Value is not a valid value (empty or null).

Please specify a valid not zero value for Actual Value to fix this issue.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Thanks @v-viig,

 

That's a real shame, since it renders the visual unusable for the purpose I had in mind. Which is a real pity because this visual is (was) a real asset since it seems to combine a lot of the virtues contained in a number of other visuals. It would be fantastic if there was a workaround or an update to allow for this kind of instances. But as it is, The risk of providing inacurate information is obvious unfortunately.

 

As a thought, is this event actually documented in the visual's descritpion? (because I think it's a very relevant characteristic)

 

Thanks again for your clarification,

 

Best regards,

 

Paul.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






We're going to release Power KPI Matrix 2.1.0 next week that supports zero values.

Once this version is released you might try to set null value to zero to render the column.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

@v-viig, good morning,

 

Sorry to bring this thread up again, but since I'm patiently awaiting the new update on Power KPI Matrix, is there a way to know when the new update is published so I can keep an eye on the new release?

 

Thank you,

 

Paul.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






I know this is several months later- but I recently added PowerKPI matrix to my report and I cannot seem to find the zero value setting (or indeed the Actual Value setting).

 

v-viig
Community Champion
Community Champion

@seebert42 You can find "Treat zero values as nulls" under Current Value group of Formatting Panel.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Thank you very much for your reply- in a similar vein, can you tell me where to find the swtich to turn on Category and SubCategory is?

v-viig
Community Champion
Community Champion

Categories can not be turned off by design.

Sub-categories can be turned off by removing columns from Category data-field.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Power KPI Matrix 2.1.0 has already been released.

Zero values can be turned on in Actual Value group of formatting panel.

 

Please let me know if this feature meets your initial requirements.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Hi @v-viig,

 

Is there any way we could turn on the null value option for Camparison values?

 

Thanks

@v-viig

 

Thank you for the work! So far, so good!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Thanks @v-viig!!

 

That's great news!!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






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