Card Visual

[varshahrame]

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.

[varshahrame]

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?

[varshahrame]

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.

[Syk]

Try

No Data_Total On Rent = COALESCE([_TotalOnRent],"No Data for selected criteria")