Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
maybe you can try this
if(isblank(measure),"","No Data available")
Proud to be a Super User!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
84 | |
70 |