Need Date Slicer to Default to Most Recent/ Max Create Date

[Igotzepowerbi]

Hi,
I have a date slicer using Create Date from my JG Forecast Complete table and I am needing it to default to the Max Create Date. 
So like today I go to my report and the selected date is 02/20/2024 I need it to be the max create date which is 02/25/2024.
Is there a way to do this? Thanks so much in advance!

[PijushRoy · Accepted solution]

Hi @Igotzepowerbi 

Please create a measure MaxDate = Max(Table[Date])

Please use Custom free visual PreSelected Slicer

Create a calculated Table

_PreselectedSlicer = DATATABLE(
    "IsDirtySlicer1", BOOLEAN, "IsDirtySlicer2", BOOLEAN, 
    {
        {FALSE(), FALSE()},
        {FALSE(), TRUE()},
        {TRUE(), FALSE()},
        {TRUE(), TRUE()}
    }
)

Now create the PreSelected slicer visual

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[nsexton12]

You could add a calculated column that is that max date in your date colunn and make that the value of your slicer.