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
Community 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.

 

 

  • v-viig's avatar
    v-viig
    Community Champion
    8 years ago

    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

    [email protected]

    • akumarbvp's avatar
      akumarbvp
      Frequent Visitor
      8 years ago

      Thanks Ignat.

       

      Will be eagerly waiting for the update.

       

      Cheers !