Using IF and ISBLANK method for a card visual

[Asa94]

Hi everyone,

I have a card visual in my report that shpwcaes 2 cut off times. With the 2nd cut off times, some of the values in the column are blank and need to be shown as "No 2nd Cut Off"in the card visual. I have tried using the method shown below: 

This is the current output:

is there a way I can go about solving this? Any tips and hints would be appreciated 🙂

Regards,

A

[amitchandak · Accepted solution]

@Asa94 , You are using a text with number in if format secondcut as text or

use

if(<condition>,

"No second cut off",

, secondcut &"" )

[Asa94]

Thank you so much, I tried your second method and it worked!

Appreciate it so much!