automatically show last available date of data

[jcastr02]

How do you get the date filter end date to default to the latest data - for example when I opened the below today it was defaulted to 1/29/24 but there is data in there until 3/11/24.  I'd like for it to automatically show 3/11/2024 as last date without having to manually scroll the visual.

[Anonymous · Accepted solution]

Hi @jcastr02 

@Greg_Deckler Thanks for your sharing!

In response to your question, I offer some other thoughts for your consideration:

Here's some dummy data

"Date"

Create a new table that holds the maximum dates in the date table.

max_date = SUMMARIZE('Date', "max_date", MAX('Date'[Date]))

Manually create a relationship between two tables.

Creating a slicer with the max_date table. 

You can also change the slicer to "Single select".

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@jcastr02 Switch it to be an after slicer instead of between?