Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power BI KPI Matrix Displaying Zero Target Value

Hi   I am new to posting, but hope someone will pickup and provide some guidance.   I am using the PowerKPIMatrix 3.1.1.  It works as expected except when I have a target value of ZERO.  The cont...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Anonymous 

 

I have a new idea today. Since this metric is for "Cyber Security Incidents" and its target value is zero, I think using the absolute difference between actual value and target value would be more appropriate than using a rate percentage as a KPI. Based on previous discussion, we know that the rate percentage is always infinite when target is zero and couldn't show the difference of impact degree. But the absolute number difference can show the impact degree.

 

If you can accept this idea, we can create a new measure like below to have a different KPI calculation method for "Cyber Security Incidents" metric specially. For other metrics, it still return the difference percentage. 

KPI =
IF (
    SELECTEDVALUE ( 'tablename'[Metric] ) = "Cyber Security Incidents",
    SUM ( 'tablename'[Current Value] ) - SUM ( 'tablename'[Target Value] ),
    DIVIDE (
        SUM ( 'tablename'[Current Value] ) - SUM ( 'tablename'[Target Value] ),
        SUM ( 'tablename'[Target Value] )
    )
)

 

Then put this measure and Metric, Current Value, Target Value columns into a table visual. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for the suggestion, but the issue is not calculating/displaying the KPI value.

The issue is displaying the zero Target value in the control under the Threshold column.

 

 

I am still unable to fix this issue and it makes the control unusable.

Any help would be appreciated.

 

Karen

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello,

     

    I have exact same issue. If the target value is zero, then it still shows as blank (nothing is displayed in that cell!) and the KPI Status shows no value!

     

    Is this issue/bug fixed or has anyone been able to find a way to make this work within the Microsoft KPI Matrix visualization and display the value 0 instead of "blank"?

     

    Thanks in advance. Any help is much appreciated!