Select latest date by default + possiblity to filter other dates

[RemyBosman]

Hi all!  I'm struggling with a scenario which seemed simple to realize at first, but turns out to be not that simple. I have a report that should meet the following requirements

• By default reports should be filtered on the latest date in my date table.
• The user needs to be able to select any other date present in de date table.
• When the user closes the reports and opens it back up tomorrow, it should be showing the latest date in the date table again.
• I prefer to only make use of a date filter to make this work. Removing other filters like "IsToday" before beging able to select other dates are poor solutions in my opinion.

Any help and ideas are appreciated!

Regards, Remy

[amitchandak]

@RemyBosman , I think as of now the solution is like is today will work. You can have other dates in that

A new column like this

Is Today = if('Date'[Date]=max(Table[Date]),"Last Date",[Date]&"")

Sort it on date of your date table, so that user can select other dates too

[RemyBosman]

@amitchandak 

Thanks for your response. A column like you mentioned wont work in a proper date picker am I right? Also when using this field in the standard filters pane theres no option to sort or use a date picker. 

[v-easonf-msft · Accepted solution]

Hello, @RemyBosman

As a workaround, you can try to create a calendar table and then use the "ISFILTERED" function to create a "New Date" measure to replace the original "DATE" file:

New Date =
VAR default_date =
    TODAY () //LATEST DATE YOU WANT
RETURN
    IF (
        ISFILTERED ( 'Date'[Date] ),
        SUM ( 'Table'[Date] ),
        CALCULATE (
            SUM ( 'Table'[Date] ),
            FILTER ( 'Table', 'Table'[Date] = default_date )
        )
    )

When there is no selection in the date segmentation, the visuals will be filtered by the default date (today).

Once there is a selection in the slicer, the default value must be canceled and the visual should be filtered normally.

For more details, see the attached pbix file.

Best regards
Community Support Team _ Eason