Forum Discussion
Post PartisanDate 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 when power bi refreshes, the data filter will still show a date that has been deleted.
e.g today showed wendesday but there was no data for wendesday, i had to select Thursday Manual.
How can i get the filter to just show the latest date in the drop down.
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
3 Replies
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
- parry2k
Super User
NewbieJono use relative date filters on the filter pane or relative filter in the slicer Use a relative time slicer or filter in Power BI - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
NewbieJonoit is still defaulting to the last selected date by the user
