Forum Discussion

anileshknpowerb's avatar
anileshknpowerb
Helper III
5 years ago
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(...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    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.

anileshknpowerb's avatar
anileshknpowerb
Helper III
5 years ago

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.

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
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.