Forum Discussion
Help with Blank result
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.
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.
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
3 Replies
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
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.
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
