Forum Discussion

AlanP514's avatar
AlanP514
Post Patron
4 years ago
Solved

Dynamic Information

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




Need Help
Show and Tell
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    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

3 Replies

  • Avantika-Thakur's avatar
    Avantika-Thakur
    Solution Supplier
    4 years ago

    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

     

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    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