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 va...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    EMSSS22 , Try a measure like

     

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

EHISAdmin's avatar
EHISAdmin
Frequent Visitor
3 years ago

Use the column in a IF measure 

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