Zero Showing as Blank in Comparison Value of Power BI KPI Matrix

[sshivam]

Hello,
In Power BI's KPI Matrix visual, zero values in the Comparison Value field are appearing as blank. Unlike the Current Value field, there is no available toggle or option such as "Treat zero values as nulls" for the Comparison Value.

Question:
How can I ensure that zero is displayed correctly (and not as blank) in the Comparison Value of the KPI Matrix?

[v-dineshya]

Hi @sshivam ,

Thank you for reaching out to the Microsoft Community Forum.

You are expecting  the values  of "Comparison Value" of the KPI Matrix is "0" instead of "blank".

Please follow below steps.

1. Created table "Table" with sample data based on your screenshot. refer the snap.

2. Created Measure "Comparison Value new" to replace "blank" with "0" with below DAX code.

Comparison Value new =

VAR val = SUM('Table'[Comparison Value])

RETURN IF(val = 0, 0, val)

3.  Please refer outpur snap and attached PBIX file.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

Regards,

Dinesh

[sshivam]

Thank you for your message. However, I’d like to clarify that the Power BI KPI matrix is currently treating actual zero values as blank. My requirement is to display exact zero values as they are. The solution you provided appears to convert blank values to zero, which doesn't address the issue.

Best regards,
Shivam

[v-dineshya]

Hi @sshivam ,

Your requirement is to display exact Zero values as they are Zero . Please provide sample PBIX file. It is easy for us to replicate the scenario.

Regards,

Dinesh

[v-dineshya · Accepted solution]

Hi @sshivam ,

We haven’t heard from you on the last response and was just checking back to see. Please provide sample PBIX file.

Regards,

Dinesh

[v-dineshya]

Hi @sshivam ,

We haven’t heard from you on the last response and was just checking back to see. Please provide sample PBIX file.

Regards,

Dinesh

[v-dineshya]

Hi @sshivam ,

We haven’t heard from you on the last response and was just checking back to see. Please provide sample PBIX file.

Regards,

Dinesh

[divyed]

Hello @sshivam ,

What is the source for Comparison Value ? Is this a direct field or a measure ? 

You can either use power query to add zero for blanks or modify your dax to give zero if this is a measue.

You can try couple of things :

My Measure = COALESCE(SUM(Sales[Amount]), 0)  //replace values accordingly

OR

My Measure =
VAR Result = SUM(Sales[Amount])
RETURN IF(ISBLANK(Result), 0, Result)

I hope this helps.

Cheers.

Neeraj 

[sshivam]

Thank you for your help. I have several KPIs, each with a corresponding target value. Some KPIs have a target value of zero. There's a many-to-one relationship between the fact table and the target data table, based on the KPI title.

I want to retrieve the exact target value for each KPI in the comparison so that I can use it as a baseline in a sparkline visualization.
@divyed @bnjmnnl 

[bnjmnnl]

You can use Power Query to replace null with 0. There is a function for (on the home tab) called Replace Values. Would this work? Otherwise create a new column that replaces the blank values with 0. Maybe someone has a better option?

[bnjmnnl]

Or if the Comparison Value is a measure, just add "+0" behind

[MasonMA]

This is one recommended approach by many seasoned developers, i'd also vote for it:)