Date Filter not change when new data added

[NewbieJono]

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.

[Anonymous · Accepted solution]

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.

latest date in the slicer

Slicer Date column = IF ( 'date table'[Date] = MAX ( 'date table'[Date] ), "Latest Date", 'date table'[Date] & "" )

Select latest date in Slicer

Default Slicer Value = 

VAR MaxDate = 
CALCULATE(
    MAX( Dates[Date] ),
    ALL(Dates[Date] )
)

VAR Selected =
SELECTEDVALUE(
    Dates[Date],
    MaxDate
)

RETURN
Selected 

Best Regards

[NewbieJono]

it is still defaulting to the last selected date by the user

[parry2k]

@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.