Zeros Are getting consider as Blank

[vishal097]

Hello There,

I am working on color coding measure by comparing Actual Vs Target.

If Actual is blank - I don't want color

if Target is blank - I don't want color

if Actual & Target both are blank -  I don't want color

This can be achive by mentioning Actual <> blank() && Target <> blank()

but I have some values in target or in actual as 0 and I want to comapre them with respective target to give color but after blank condition it is showing no color.

I believe it considering 0 as Blank 

can someone help on how to fixed this issues.

[AilleryO]

Hi,

You're absolutely right, if you do a test like :

[Value]=0 or [Value]=BLANK() Power BI consider 0 and blank as the same.

To differentiate them you should use :

[Value]==0 or [Value]==BLANK() or ISBLANK( [Value]) 

all of them making a difference between null (blank) and 0.

And you can use NOT to make your test :

NOT ISBLANK( [Actual])

Hope it helps, let us know...

[Jihwan_Kim · Accepted solution]

Hi,

Please try somethnig like below.

if( Actual == blank() && Target == blank(), blank(), color condition)

by using two equal signs, ==, it only catches blank, and it does not catch zero.

[vishal097]

Thanks Worked Perfectly 🙂