Power KPI Matrix

[jguoca]

Hi,

I’ve encountered a problem when using Power KPI matrix visual and hope someone can help with.

Here is the problem: I have a data field “ytd_actual” on database table with zero (0) value. However, this field shows up as blank in KPI matrix visual. I did set the option ‘treat zero as null” to OFF.

Any idea about the cause and solution to fix it?

Much appreciate!

Jack

[v-chuncz-msft]

@jguoca,

It would be better to share a complete example. By the way, here is a forum dedicated to Custom Visuals Development.

[jguoca]

@v-chuncz-msft Thanks for your follow-up. I am not able to attach the sample report due to the large dataset. However, the attached snapshot will give you a rough idea about the problem. It shows that there are two indicators that have ytd_actual shows up with blank but they actually have zero (0) in the source database table. Thanks!