Forum Discussion

akumarbvp's avatar
akumarbvp
Frequent Visitor
8 years ago

PowerKPIMatrixEB second comparison value treats 0 as null and displays blank cell where value is 0

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...
v-viig's avatar
v-viig
Icon for Community Champion rankCommunity Champion
8 years ago

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

[email protected]

akumarbvp's avatar
akumarbvp
Frequent Visitor
8 years ago

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.