Forum Discussion

guruprasathb's avatar
guruprasathb
Regular Visitor
8 years ago

Display current date in date slicer starting date

Hi,

 

I have requirement to display current date (Today ()) in date slicer filter. Basically my requirement is display current date as start date in slicer.

 

Thanks,

Guru

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi You just need today in slicer? Create a column with the below DAX and create a slicer based on this.

     

    Today Column= TODAY()

     

    I think you may need more on top of this, if so please share details.

     

    Thanks
    Raj

    • guruprasathb's avatar
      guruprasathb
      Regular Visitor
      8 years ago

      Thanks for quick response. If I do that then I am unable to scroll (Move) the slicer. 

       

      Default values to be set when the report loads first time. 

       

      Thanks,

      Guru

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Yes, TODAY () represnents just today, so you will have just one day in the slicer and hence you dont have the scroll option.

         

        Could you please explain your requirement in detail? If posible with sample data/ snapshot.

         

        Thanks
        Raj

  • erinn_mitchell's avatar
    erinn_mitchell
    Advocate I
    7 years ago

    Hello!

     

    I know this was 2 months ago but came across this while searching for something else. If you hover over the slicer header, click the carrot, and then select "Relative". This date slicer type allows you to specificy "Last 1 day" or "Last 1 week" as shown below so that the default date is dynamic.

     

    Hope this helps!