Card visual shows the last day, and (blank) for other days

[Anonymous]

By default, the filter for the card visual is set to "last day", but if I select a day earlier or any other date earlier than the actual day, it shows "blank". How can I set the conditions so if its in a "free state" the visual shows "today", but if I choose a different date, it reflects it?

Appreciated.

[v-shex-msft · Accepted solution]

HI @Anonymous,

You can try to use the following measure formula if it meets your requirement.

Measure =
IF (
    ISFILTERED ( Table[Date] ) = FALSE ()
        || SELECTEDVALUE ( Table[Date] ) = TODAY (),
    TODAY ()
)

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , try isfiltered https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

a measure like

if(isfiltered(Date[Date]), selectedvalue(Date[date]), today())