Help with Blank result

[juhoneyighot]

Hello!

Anyone how I can rid of this Blank that shows in the visual.

If it has no value just don't show [Blank]

Thank you.

[danextian · Accepted solution]

Hi @juhoneyighot 

You can use COALESCE("", [mymeasure]) to return blank as an empty string but that will return a text. Alternatively, you can use conditional formatting on font color to make the blanks transparent. Example conditional formatting

IF ( ISBLANK ( [mymeasure] ), "RGBA(0,0,0,0)" )

 This is to be used font color conditional formatting as field value.

[Anonymous · Accepted solution]

Hi @juhoneyighot ,

You can use ISBLANK() to determine whether the returned result is balnk and return "".

For example.

Measure = IF(ISBLANK(returned result),"",returned result)

Best regards,

Mengmeng Li

[danextian · Accepted solution]

Hi @juhoneyighot 

You can use COALESCE("", [mymeasure]) to return blank as an empty string but that will return a text. Alternatively, you can use conditional formatting on font color to make the blanks transparent. Example conditional formatting

IF ( ISBLANK ( [mymeasure] ), "RGBA(0,0,0,0)" )

 This is to be used font color conditional formatting as field value.

[dharmendars007]

Hello @juhoneyighot , 

Replace Blank Values in DAX Measures

Measure =
IF(ISBLANK(SUM(Table[Column])),
BLANK(),
SUM(Table[Column]))

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN