Forum Discussion

DonIncognito's avatar
DonIncognito
Icon for Helper I rankHelper I
5 years ago

Slicer returning results outside date range

I have a date slicer hooked up to a date table. The slicer has two filters, one for anything after 1/1/2020, and one for choosing the end date using the date offset calculation.   If I have the beg...
Need Help
DonIncognito's avatar
DonIncognito
Icon for Helper I rankHelper I
5 years ago

Hi v-janeyg-msft

 

Thanks for your efforts, they are much appreciated, but it has not solved my issue. It got rid of the blank lines perfectly, but that was a side effect and not the main problem. I have cleaned up that issue, so now there are no lines with a blank date in them, but I'm still getting results returned from outside the dates set on the slicer.

 

 

 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, DonIncognito 

     

    The problem may occur elsewhere.Whether the 'date' of the date slicer and the 'date' in the table are in the same field or in different tables?

    Could you mind providing some sample data or more information about the table like relationships,fields and measure?So we can help you soon.

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.