Dynamic Information

[AlanP514]

Hi All, 
I have a requirement, Please help with this 
The requirement is I want to create a title name it should be dynamic .


If the user selects any date from the date slicer, if that particular date data is available the title should show blank  and vice versa
1St scenario: If data is available the title should be blank which means no need to show anything 
2Nd Scenario: If data is not available it should Dynamically show "No Data available"

Please help me to achieve this Dax

[v-luwang-msft · Accepted solution]

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

[ryan_mayu]

@AlanP514 

maybe you can try this

if(isblank(measure),"","No Data available")

[Avantika-Thakur]

Hi @AlanP514 ,

You can try creating a DAX like below :

Dynamic text = IF( selectedvalue(Date) <> BLANK()," ", "No-data Available")

Hope this helps.

Please accept the solution if it answers your query.

Thanks!
Avantika