Dynamic Information

Hi AlanP514 ,

Based on your description, it seems to me that you should have two columns of data, one as the date used by the slicer, and the other as the date available. When the date selected by the slicer is in the available dates, then blank is returned, and when the slicer's date is not in the available dates, then No Data available is returned.
Refer to the following.

Availtable:

Slicer table:

create the below measure:

test =
VAR test1 =
    CONCATENATEX ( ALLSELECTED ( 'Slicer Date' ), 'Slicer Date'[Date] )
VAR test2 =
    CONCATENATEX ( AvailDate, AvailDate[Date] )
RETURN
    IF ( ISERROR ( FIND ( test1, test2 ) ), "No Data available", BLANK () )

Output result:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien