Forum Discussion
NewbieJono
Post Partisan
4 years agoDate Filter not change when new data added
Hello, Every day i add a new set of data. Some days i add the past 3 days (weekends). This data overwrites the current data. so there is only ever the past 1-3 days of data there. However w...
- Anonymous4 years ago
Hi NewbieJono ,
Do you want to set the default selection of Date slicer with latest date? If yes, you can refer the following links to achieve it.
Slicer Date column = IF ( 'date table'[Date] = MAX ( 'date table'[Date] ), "Latest Date", 'date table'[Date] & "" )Default Slicer Value = VAR MaxDate = CALCULATE( MAX( Dates[Date] ), ALL(Dates[Date] ) ) VAR Selected = SELECTEDVALUE( Dates[Date], MaxDate ) RETURN SelectedBest Regards
NewbieJono
Post Partisan
4 years agoit is still defaulting to the last selected date by the user