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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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