PowerKPIMatrixEB second comparison value treats 0 ...

akumarbvp · ‎05-31-2018

Hey Guys,

I am facing a stange issue with PowerKPIMatrixEB. Matrix treats 0 as null and displays a blank cell for Second Comparison Value. Although I can see an option within Current Value format to control this via the option 'Treat Zero as Null', but 'Treat Zero as Null' configuration is not available with other parameters.

akumarbvp · ‎05-31-2018

Hey Guys,

I am facing an issue with PowerKPIMatrix EB visual. This visual is displaying 0 as null (blank cell) for second comparison value. There is a control available for this within format section for Current Value with a configuration name 'Treat Zero as Null', however same is not available for second comarison value or other parameters. Not sure if there is any alternative way to display a value zero within PowerKPIMatrix seocnd comparison value. Any leads would be of great help.

Cheers!

v-viig · ‎06-04-2018

Comparison Value and Second Comparison Value do not support zero values as a variance will be not a number due to dividing by zero.

Could you please describe why it's required in your case?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

akumarbvp · ‎06-06-2018

Hey Ignat,

The dataset i have has a comparison and second comparison value of '0' while actual value can be anything (let say also 0 in this case).

In this case there is a variance of 0 % when compared with either comparison value. Instead of showing 0 % variation, corresponding cell within matrix shows blank. So it does not give the right picture to the consumer of the report.

I can understand your point of division by 0 leads to infinity, but there must be a way to convey this information via some text or symbol instead of leaving the cell blank and making it open for interpretation.