Visuel segment : how to define start andend date

Thanks for the reply from parry2k.

Hi Djam75 ,

Based on the description of your problem, I achieved what you need by creating a new table as a field for the slicer and changing a setting, here are the exact steps I took:

1.Create a new table:

NewTable = CALENDAR(DATE(YEAR(TODAY()), 1, 1),TODAY() - 1)

2.Create the relationship:

3.Create the visuals:

4.Then go to File>Options and settings>Options. Under Current File, select Report settings. Click on the box "Don’t allow end users to save filters on this file in the Power BI service".

This ensures that every time a report is opened, it will display the default filters set by the report creator.

Best Regards,
Zhu
Community Support Team

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