Date Filter with pre-defined values and possibility to extend

[Mariollodcg]

Hi,

I have a table with range of dates from 01.01.2015 to 31.12.2024 (bookings ahead of time) and with some blanks

On a default state I want to show data between 01.01.2022 and TODAY without blanks.

But I do not want to cut the rest of data, I want to let users extend the filter on their own when needed,

I am struggling with this. thought that creation of new column like 

DateFilter = TODAY() > table[column]

will solve the problem but it did not. It only filters the date filter but not the actual data in the raw data table.

Can you guys help?

[lbendlin]

Here's the general approach - modify as needed:

- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app

[Mariollodcg]

This approach will cut my data.

What I am trying to get is date slicer like this on default state (with possibility of extension by user on data on BEFORE and AFTER default).

Like on a screen: