Forum Discussion

lburgess's avatar
lburgess
Helper II
8 years ago
Solved

power kpi matrix

Not sure whether this is the correct location to post this, but here goes...   I downloaded the new Power KPI Matrix today. It provides the balanced scorecard reporting that I had been looking for....
  • v-viig's avatar
    v-viig
    8 years ago

    Power KPI Matrix supports zero values now by enabling a toggle at Actual Value group of Formatting Panel.

     

    Ignat Vilesov,

    Software Engineer

     

    Microsoft Power BI Custom Visuals

    [email protected]

nerdalert1's avatar
nerdalert1
New Member
8 years ago

Thanks for adding the ability to treat zeros as values.  I'm now able to enable that for my actuals, but it's still not working for the comparison value.  Zero is a legitimate value for a comparison as well.  Am I missing this, or is it possible to add in a future release?

 

Thank you.

  • lburgess's avatar
    lburgess
    Helper II
    8 years ago

    Excellent point! I had missed that there was no option to not treat zero as null for the comparison value or second comparision value.  To me, there should be the option to treat zero as a valid value for all values.  Otherwise, the visualization is essentially useless for me.

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

      Zero values are not supported for Comparison values since the varaince will be NaN (current value / comparison value).

      This is the main reason why we implemented Zero values only for Current/Actual values.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • lburgess's avatar
        lburgess
        Helper II
        8 years ago

        So what will the visual display when the comparison value is 0?