Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hello,
I have this weekly report I distribute every monday. I find situations where dates are blank as displayed below and all data is displayed in the previous week bar. I need an expression to replace the blank date with current date so that I can have the fourth bar instead of 3 bars as shown below. Your suggestions will be appreciated.
Solved! Go to Solution.
Hello,
I tried implementing this but I get this error below . How can I clear the error?
iif(Fields!WeekStart.Value = Blank(), Today(), Fields!WeekStart.Value)
Hi @M_nwadibia,
sorry, my fault. Blank doesn't work in ReportBuilder.
Please try the following:
=iif(cstr(Fields!WeekStart.Value) = "", Today(), Fields!WeekStart.Value)
Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ
Hi M_nwadibia,
this should work: =iif(Fields!Date.Value = Blank(), Today(), Fields!Date.Value)
Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ
Hello,
I tried implementing this but I get this error below . How can I clear the error?
iif(Fields!WeekStart.Value = Blank(), Today(), Fields!WeekStart.Value)
Hi @M_nwadibia,
sorry, my fault. Blank doesn't work in ReportBuilder.
Please try the following:
=iif(cstr(Fields!WeekStart.Value) = "", Today(), Fields!WeekStart.Value)
Liked this post? More Content on:
https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ
You can create a simple calculated date column with a formula like below :
Date_Adjusted =
IF ( ISBLANK ( 'Table'[Date] ), TODAY (), 'Table'[Date] )
If this post is helpful, please consider marking it as a solution so that other users may find it more easily.
Oh I did not mention that this is SSRS expression and not power Bi. Thanks
Ah sorry I thought it was Power BI.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
2 |