Forum Discussion

EricChen's avatar
EricChen
Microsoft Employee
3 years ago

POWER KPI MATRIX 3.1.1.

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 highlig...
Need Help
vh_'s avatar
vh_
New Member
1 year ago

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!