Forum Discussion

NewbieJono's avatar
NewbieJono
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Date 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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 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.

    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

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

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.