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 control displays a blank field. This is a valid target - consider outstanding issues. I have looked at different solutions, but none seem to resolve the issue. Please help!!! ThanksKaren

I have a table storing the target values. Ones with >0 display as expected, but if the target =0 then the control displays blank. Please let me know if you need more information.

Hi Anonymous It seems KPI Status is calculated with a formula like DIVIDE([Current Value] - [Target Value], [Target Value]). So when a target value is zero, it returns the optional value blank as zero cannot be the divisor. Maybe you can create a measure to calculate the result by your own and put this measure into a Matrix visual to display the difference percentages. Best Regards, Community Support Team _ JingIf this post helps, please Accept it as Solution to help other members find it.

Hi Jing "It seems KPI Status is calculated with a formula like DIVIDE([Current Value] - [Target Value], [Target Value]). So when a target value is zero, it returns the optional value blank as zero cannot be the divisor. Maybe you can create a measure to calculate the result by your own and put this measure into a Matrix visual to display the difference percentages. " The logic makes sense, but could you please suggest how I use a measure without running into the same logic? ThanksKaren

Hi Anonymous When the divisor is zero, any increase or decrease percentage would be infinite, which is mathematically meaningless. I'm not in your situation so I'm not able to suggest which optional result can meet your need better when the target value is zero. It's up to you. You can create a measure like below and replace "whatever" with the value you want for the special case when target value is zero. rate = DIVIDE ( SUM ( 'tablename'[Current Value] ) - SUM ( 'tablename'[Target Value] ), SUM ( 'tablename'[Target Value] ), "whatever" ) I put it in a table visual as below. There are many discussions about how to calculate growth percent when start value is 0. You can refer to below discussions or google a bit to get some ideas. calculation - What is the correct answer for percent change when the start amount is zero dollars $0? - Personal Finance & Money Stack Exchange math - How to calculate percentage when old value is ZERO - Stack Overflow How to get a percentage increase from a base of 0 in Excel - Quora Best regards, Jing If this post helps, please Accept it as Solution to help other members find it.

Thanks for the replies, but maybe its not clear what I am trying. The target value is an absolute Zero. As in Zero High Impact incidents. I am still not seeing a solution that allows the control to display and use the zero value as a target.

Power BI KPI Matrix Displaying Zero Target Value

11 Replies

v-jingzhang
Community Support
4 years ago
Hi Anonymous

It seems KPI Status is calculated with a formula like DIVIDE([Current Value] - [Target Value], [Target Value]). So when a target value is zero, it returns the optional value blank as zero cannot be the divisor.

Maybe you can create a measure to calculate the result by your own and put this measure into a Matrix visual to display the difference percentages.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Pragati11
Super User
4 years ago
Hi Anonymous ,

Can you try adding some more information like screenshots of the visual, etc. to explain your issue a bit more?

You can refer following blog on how to get your question answered on the forum:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message

Thanks,

Pragati
- Anonymous
  Not applicable
  4 years ago
  I have a table storing the target values. Ones with >0 display as expected, but if the target =0 then the control displays blank.
  
  Please let me know if you need more information.
  - Anonymous
    Not applicable
    4 years ago
    Hi Jing
    
    "
    It seems KPI Status is calculated with a formula like DIVIDE([Current Value] - [Target Value], [Target Value]). So when a target value is zero, it returns the optional value blank as zero cannot be the divisor.
    
    Maybe you can create a measure to calculate the result by your own and put this measure into a Matrix visual to display the difference percentages. "
    
    The logic makes sense, but could you please suggest how I use a measure without running into the same logic?
    
    Thanks
    Karen
Nouches
Frequent Visitor
3 years ago
I'm facing the same problem!
Has anyone found a workaround this?
Thank you
Anonymous
Not applicable
2 years ago
Anyone has a Solution for that problem?

Forum Discussion

Power BI KPI Matrix Displaying Zero Target Value

11 Replies

Related content

display total in matrix visual

Display row in matrix

Matrix column headers display

Matrix table

Power BI Matrix Expand/Collapse Button Display