Slicer in power BI

[rpco53]

A have a slicer with  a date field from a calendar table which cover from 01/01/2020 to today. I want to know if there is anyway that upon starting the dashboard I can make the slicer start a the beginning of the month instead of 1/1/2020 and yet have the ability of moving that date on the slider to any previous date. 

[Anonymous · Accepted solution]

Hi @rpco53 ,

us , There is no way to initialize the date on today. Create a column like this in your date table and filter on that

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

or

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

Sort these on date if needed

refer : https://www.youtube.com/watch?v=hfn05preQYA

I have also found a similar post, please refer to it to see if it helps you.

Solved: Set TODAY as default date in slicer visual - Microsoft Power BI Community

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RAHULBANDI]

create new table >> use calenderauto()

have realionship between them

it will help having date from the begining of the month

[rpco53]

Is this what you mean two slicers. This does not work as you can see.

[RAHULBANDI]

hi

if you are looking for this type of result 

jan-01

feb-01

mar-01

go to your table >> Add new column >> use Format 

[rpco53]

No the slicer shows 01/01/2020 to 10/05/2022 I want that starting the DashBoard it show 10/01/2022 to 10/05/2022 for this today month of october  and if I open it in november 14 of this year it shows 11/01/2022 to 11/14/2022 yet I can move the slicer to any date range of the period from 01/01/2020 to today. Basically I want the slicer to show the dates from the beginning of the month we are in to the day of the month we are at yet allowing me to select any date from the range that I have from 01/01/2020 to today.