Forum Discussion
Solved
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(...
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.
Hi anileshknpowerb,
You can drag a column which contains blank value into slicer.
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
The user requirement is to use dates between option in 'Completed Date' slicer. User want to see what are the Records fall between selected date ranges , along with records that have NULL values for Completed Date.