Date Slicer not updating after the scheduled refresh

[FreedJustine]

Need some help. After schedule refresh, datasets are updated however my date slicer is still stuck in yesterday's date, I need to manually refresh so it will reflect the date slicer.

I use 2 date table

DATE_ =

ADDCOLUMNS (

CALENDAR (DATE(2022,1,1),TODAY()),

"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),

"Yr.", YEAR ( [Date] ),

"Monthnumber", FORMAT ( [Date], "MM" ),

"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),

"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),

"Month", FORMAT ( [Date],"mmm" ),

"MonthNameLong", FORMAT ( [Date], "mmmm" ),

"Mo. & Yr.", FORMAT([Date],"MMM YYYY"),

"DayOfWeekNumber", WEEKDAY ( [Date] ),

"DayOfWeek", FORMAT ( [Date], "dddd" ),

"DayOfWeekShort", FORMAT ( [Date], "ddd" ),

"Qtr.", "Q" & FORMAT ( [Date], "Q" ),

"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ),

"DateNo.",FORMAT([Date],"DD")

)

___________________________________

___________________________________

SpecialDates =

VAR _datetable = DATE_

VAR _today = TODAY()

VAR _month = MONTH(TODAY())

VAR _year = YEAR(TODAY())

VAR _thismonthstart = DATE(_year,_month,1)

VAR _thisyearstart = DATE(_year,1,1)

VAR _lastmonthstart = EDATE(_thismonthstart,-1)

VAR _lastmonthend = _thismonthstart-1

VAR _thisquarterstart = DATE(YEAR(_today),SWITCH(true,_month>9,10,_month>6,7,_month>3,4,1),1)

RETURN UNION(

ADDCOLUMNS(FILTER(_datetable,[Date]=_today),"Period","Today","Order",1),

ADDCOLUMNS(FILTER(_datetable,[Date]=_today-1),"Period","Yesterday","Order",2),

ADDCOLUMNS(FILTER(_datetable,[Date]>_today-7),"Period","Last 7 Days","Order",3),

ADDCOLUMNS(FILTER(_datetable,[Date]>=_thismonthstart),"Period","This Month","Order",4),

ADDCOLUMNS(FILTER(_datetable,[Date]>=_thisquarterstart),"Period","This Quarter","Order",5),

ADDCOLUMNS(FILTER(_datetable,[Date]>=_thisyearstart),"Period","This Year","Order",6),

ADDCOLUMNS(FILTER(_datetable,[Date]>_today-30),"Period","Last 30 Days","Order",7),

ADDCOLUMNS(_datetable,"Period","Custom...","Order",8)

)

[ribisht17]

@FreedJustine 

@lbendlin  answer is correct but 

A few worarounds here Solved: Slicer on Filtered Dataset not updating online - Microsoft Power BI Community

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[lbendlin · Accepted solution]

That is working as designed. The only scenarios that will automatically refresh the browser screen is a dashboard behind a dataset that just got updated,  or a report with direct query data source and automatic page refresh.