Forum Discussion

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

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

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
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
- guruprasathb
  Regular Visitor
  8 years ago
  I have Calculated table created for Dates (From 1st of Jan 2000 to 31st of Dec 2018). It is perfectly working fine with the datasets.
  
  Business user wants to set the default dates for the slicer whenever the dashboard opens.
  
  Say for example:
  If the report opens today, then FromDate in the slicer is 9-Aug-2018 & ToDate is 31st Dec 2018.
  If the dashboard viewed tomorrow then FromDate in the slicer is 10-Aug-2018 & ToDate is 31st Dec 2018.
  
  Right now, the challenge is I can't able to set the DEFAULT value for date slicer. Hope it is clear. Kindly let me know if there is any workaround. Thanks in Advance.
  - Anonymous
    Not applicable
    8 years ago
    guruprasathb,
    
    It is not possible to set default date in slicer as you describe. There are some ideas about this issue, please vote them up.
    
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19055692-slicer-default-selected-values
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-or-tile-by-value-configura
    
    Regards,
    Lydia