Power KPI Matrix - treat zero values as null comparison values

[Anonymous]

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?

[vh_]

I am new to PowerBI and had this issue just yesterday - changed the measures used Comparison and Second Comparison values slightly.

Introduced an If condition in RETURN to check if the value was Blank() or 0 and assigned a small non-zero value such as 0.00001. This was done in all 3 measures used as Actual, Comparison and Second Comparison and the issue got resolved. It is just a workaround you can try while an actual the item gets picked up from the change backlog.

Please mark as "Solved" if it solves the problem!

[paulbodman]

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

[v-evelk · Accepted solution]

Hi,

These feature is already in the visaul backlog.

Thanks!

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

[jmb]

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.