Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power KPI Matrix - treat zero values as null comparison values

Hi,   In the Power KPI Matrix visual it's possible to set the option for "Treat zero values as null" for Current Value, however this option is missing for Comparison Value / Second Comparison Value...
  • v-evelk's avatar
    v-evelk
    7 years ago

    Hi,

     

    These feature is already in the visaul backlog.

     

    Thanks!

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

     

     

vh_'s avatar
vh_
New Member
1 year ago

I am new to PowerBI and had this issue just yesterday - changed the measures used Comparison and Second Comparison values slightly.

 

Introduced an If condition in RETURN to check if the value was Blank() or 0 and assigned a small non-zero value such as 0.00001. This was done in all 3 measures used as Actual, Comparison and Second Comparison and the issue got resolved. It is just a workaround you can try while an actual the item gets picked up from the change backlog.

Please mark as "Solved" if it solves the problem!