Forum Discussion

anileshknpowerb's avatar
anileshknpowerb
Icon for Helper III rankHelper 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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Did you enable the "Show items with no data"  setting?

  • anileshknpowerb's avatar
    anileshknpowerb
    Icon for Helper III rankHelper III
    5 years ago

    Yes, but it didn't help