Forum Discussion

AmyJessica02's avatar
AmyJessica02
Icon for Helper I rankHelper I
4 years ago
Solved

Relative day slicer not using my date table

Hi,   Has anyone else found an issue where you use the relative date slicer, with your own date table ( i have turned off power bi's auto date functions and set my date table as a date table), and ...
Need Help
Tips and Tricks
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi AmyJessica02 ,

     

    Filtering by slicer differs from filter in that it does not use the "include today" function.

    The selection of 24/01/2022 depends on the selection of the checkbox corresponding to the date field in the filter. If you want to display only the data corresponding to the full number of days then uncheck "include today" (the data for 24/01/2022 will not be included).


    If the problem is still not resolved, please point it out. Looking forward to your reply.


    Best Regards,
    Henry


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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

AmyJessica02 , I think the relative date slicer is based on today's date?

  • AmyJessica02's avatar
    AmyJessica02
    Icon for Helper I rankHelper I
    4 years ago

    Thanks for your reply! Do you know if thats the default setting? Seem's strange it only uses it for that and you can't edit.