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

Power KPI Matrix - treat zero values as null comparison values

Hi,

 

In the Power KPI Matrix visual it's possible to set the option for "Treat zero values as null" for Current Value, however this option is missing for Comparison Value / Second Comparison Value. It is fairly common to have a zero as a KPI target, especially when thinking of health & safety (zero injury KPI for example), so it looks a little strange having an actual (current) value of 0 and a target (comparison) value of blank!

 

Would it be possible to add in the "Treat zero values as null" on/off for Comparison Value & Second Comparison Value?

1 ACCEPTED SOLUTION
v-evelk
Employee
Employee

Hi,

 

These feature is already in the visaul backlog.

 

Thanks!

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

 

 

View solution in original post

3 REPLIES 3
paulbodman
New Member

also looking forward to this update! it does still look very odd to have comparison as null instead of blank

v-evelk
Employee
Employee

Hi,

 

These feature is already in the visaul backlog.

 

Thanks!

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

 

 

jmb
Regular Visitor

Hi, I couldn't find any option to get the comparizon field to take 0 as 0 (rather then null) in PowerMatrix 3.1.1. Is there a better version ? Is there any horizon date to have this included ? 

 

thanks in advance for your answer.

 

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.