Forum Discussion
anileshknpowerb
5 years agoHelper III
Need help on date range slicer
Hello experts, I have following reporting requirement. Below are my slicers: Note : Completed Date is NULL for Status='New' and Status='Rejected' Status Completed Date(...
- 5 years ago
Hi anileshknpowerb,
You can not filter null values in Between mode:
Here is a workaround is to replace the null values with virtual dates, such as any date that qualifies.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
5 years agoSuper User
Did you enable the "Show items with no data" setting?
anileshknpowerb
5 years agoHelper III
Yes, but it didn't help