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.

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

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.

  • 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.