i am using Between date slicer and i want to set start date and end date dynamically

[Bhavyabujji]

Hi Team,

I have date column in my database and i have dates between in start date 10/10/2018 and end date 20/12/2018.

I am creating date slicer (between date slicer in am using) by selecting the date column as input. Please find below screenshot.total dates from databaseNow by defualt when ever report loads i want to set between date slicer values as start date = 10/12/2018 and end date = 21/12/2018 i.e., last week mondoy to today date(i have formula to get the dates,

PreviousweekMonday = NOW()-7-WEEKDAY(NOW(),3) but not able to set these dates when report loads. manually i am setting the dates for your reference please check the screenshot and help me in setting these dates to between date slicer by default.

Want to adjust the dates by default from last monday to today date

[elenton]

@Bhavyabujji did you ever find a way to get this working or is it still something power bi cant do as i would like to do the same on my report but dont like using the relative option.

[Anonymous]

HI @Bhavyabujji,

Nope, current power bi not support to setting default value on slicer. Maybe you can try to use relative slicer to choose last date period.

Regards,

Xiaoxin Sheng