POWER KPI MATRIX 3.1.1.

[EricChen]

Hi All,

I have a problem using POWER KPI MATRIX 3.1.1. When the value of "Current Value", "Comparison Value", and "Second Comparison Value" are zero, the table will be showing missing (as highlighted in yellow) instead of 0.00%.

There is an option for "Current Value" as "Treat zero values as nulls". After turning off this option, the missing value for "Current Value" will be 0.00%, as shown below

However, there is NO such option for "Comparison Value" and "Second Comparison Value". Do you know how to enable the same option for "Comparison Value" and "Second Comparison Value"? I would like all three values to be 0.00% instead of treating them as nulls. Thanks.

@amitchandak, @Greg_Deckler , @parry2k , @v-shex-msft

[vh_]

Change the measure or whatever you are using as Comparison and Second Comparison value to return a small non zero value such as 0.00001 in case it is blank() or 0 and it should work. If it still does not, change the Actual value measure too to have this condition. It should definitely work. Keep in mind it's only a workaround and not a solution.

Please hit "Solved" if I was able to help!