Display current date in date slicer starting date

[guruprasathb]

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

[erinn_mitchell]

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!

[Anonymous]

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]

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]

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]

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.

[v-yuezhe-msft]

@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-...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-o...

Regards,
Lydia