Forum Discussion
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 to control this via the option 'Treat Zero as Null', but 'Treat Zero as Null' configuration is not available with other parameters.
5 Replies
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!
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
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.
Thanks for the feedback. I think your idea makes sense.
This issue has been included into our backlog (#26548).
We'll update this thread once it's implemented (no ETA so far).
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
