Forum Discussion

EMSSS22's avatar
EMSSS22
Icon for Helper I rankHelper I
3 years ago
Solved

When Card visual with filters is BLANK replace with Text

I am using a card visual to show text from column called [Subject] from table Append1. 
I have a filter on the card visual to only show when another column [Area] from table Append1 is a specific value. So as expected the card will sometimes show (Blank). I want to replace the blank with text "Free", I have tried to put this in a measure but it isn't working. Please help! 

 

 

2 Replies

  • EMSSS22 , Try a measure like

     

    If( isblank(Max(Table[Append])), "Free", Max(Table[Append]))

  • EHISAdmin's avatar
    EHISAdmin
    Frequent Visitor

    Use the column in a IF measure 

    =IF (Append[Subject] = "", "Free", Append[Subject])