Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Date Slicer Between - Default to specific date

Hi!  I have a report that uses a dates slicer (between) to filter the visuals.    My users wanted to open the report everyday and have the slicer set to a default time range with the max dat set t...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , As of now I doubt you can default the date range slicer.

 

We do a workaround for normal slicer to have column  like

 

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today",'Date'[Date]=TODAY()-1,"Yesterday",'Date'[Date]&"")

 

and save it for yesterday

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    hii, yes i have considered that solution but it works only if i use a slicer as a dropdown or list, because i'm mixing Text ("Yesterday" and "Today") with my date values. If i use the slicer style "Between" that will not work unfortunately. 

     

    meawnhile i have found a work around which was to limit my calendar to end in "yesterday", this way my card visual will not be blank.

     

    problem is now if i have other pages in the report that, for example, have forecast and need the calendar to end in something like 31-12-2023