Forum Discussion

varshahrame's avatar
varshahrame
Frequent Visitor
3 years ago

Card Visual

Hi,

 

I have a card visual and I was able to successfully create a measure that would display a message when it is blank as such:

 

No Data_Total On Rent =
VAR _TotalOnRent =([Total On Rent])
return
IF(ISBLANK(_TotalOnRent),"No data for the selected criteria",_TotalOnRent)
 
However, it is not working for a Text field when it is blank, meaning my field is not appearing in the [ ] area when I type it in.
 
Any help is much appreciated, thank you.
 
 
Need Help

3 Replies

  • Syk's avatar
    Syk
    Resident Rockstar
    3 years ago

    Try

    No Data_Total On Rent = COALESCE([_TotalOnRent],"No Data for selected criteria")
  • varshahrame's avatar
    varshahrame
    Frequent Visitor
    3 years ago

    So that is not working for me, the field I have is called Risk Status, so there is a Low, Medium, High and then blank and my field risk status is not popping up when I start typing it in.

  • varshahrame's avatar
    varshahrame
    Frequent Visitor
    3 years ago

    So I think the ISBLANK function will not work because the field I am pulling in is a table and not a scalar value. Is there a way around this?