Power KPI Matrix

jguoca · ‎07-24-2018

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 · ‎07-25-2018

@jguoca,

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jguoca · ‎07-25-2018

@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!