[HELP] FILTER DATE DEFAULT START DATE

[DevGianArt]

Hi Power BI Experts,

I would l to see for your help regarding how to have a default start date and end date.
I have a table with date column named icnident date but the filter is is not today by default.

What I want to achieve is the default date should be the current date and the end date should be the month end date of the year.

example: 8/8/2023 - 12/31/2023 and also I want to be able to adjust the filter for the past 6 years

How to achieve this one? 

Thanks in advance guys!

[v-stephen-msft · Accepted solution]

Hi @DevGianArt ,

Yes, it's possible. You can create a measure for the date slicer.

Measure = IF(MAX('Table'[Date])>=TODAY()&&MAX('Table'[Date])<=DATE(YEAR(TODAY()),12,31),1)

Put the measure into the visual-level filters, set up show items when the value is 1.

Best Regards,

Stephen Tao

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