Modify Slicer Date

[amabrenda1986]

Hello

I have a date slicer as seen in the screen shot below. The date is based on the calendar table. the start date picks the min date and the end date is the always today's date. 

I want to adjust the default start date on the slicer to always start from Jan 1 2020 but the user should always have the ability to adjsut the date back to 9/18/1981.

Please how can i do this

[v-kaiyue-msft · Accepted solution]

Hi @amabrenda1986 ,

Thanks for the reply from bhanu_gautam , please allow me to provide another insight: 

You can filter the data in the slicer visual in the filters pane on the right to get only data from 1 January 2020 onwards.

More details about filters can be found in the documentation: Add a filter to a report in Power BI - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[amabrenda1986 · Accepted solution]

@v-kaiyue-msft & @bhanu_gautam thank you. I used this option in the screen shot below to get what I am looking for

[v-kaiyue-msft · Accepted solution]

Hi @amabrenda1986 ,

Thanks for the reply from bhanu_gautam , please allow me to provide another insight: 

You can filter the data in the slicer visual in the filters pane on the right to get only data from 1 January 2020 onwards.

More details about filters can be found in the documentation: Add a filter to a report in Power BI - Power BI | Microsoft Learn

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[amabrenda1986]

@bhanu_gautam thank you so much for the response but would your solution also ensure that the date is auto changed every year?

E.g. In 2024, the start date on the slicer should be Jan 01 2020 and in 2025, the start date should be Jan 01 2026 and in 2027 the start date will be Jan 01 2028 etc. This will be dynamically done by the system.

[amabrenda1986]

@v-kaiyue-msft thank you so much for the response but would your solution also ensure that the date is auto changed every year?

E.g. In 2024, the start date on the slicer should be Jan 01 2020 and in 2025, the start date should be Jan 01 2026 and in 2027 the start date will be Jan 01 2028 etc. This will be dynamically done by the system.

[bhanu_gautam]

@amabrenda1986 , Try using below steps

Create a Calculated Column for Default Start Date: Add a calculated column to your calendar table that sets the default start date to January 1, 2020, but allows for the full range of dates.
DefaultStartDate = IF(Calendar[Date] < DATE(2020, 1, 1), DATE(2020, 1, 1), Calendar[Date])

Create a Measure for the Slicer: Create a measure that will be used in the slicer to set the default start date.
SelectedStartDate =
IF(
ISFILTERED(Calendar[Date]),
MIN(Calendar[Date]),
DATE(2020, 1, 1)
)

Set Up the Slicer: Use the SelectedStartDate measure in your slicer. This will ensure that the slicer defaults to January 1, 2020, but users can still adjust it back to September 18, 1981.

Adjust the Slicer Settings: Ensure that the slicer settings allow for the full range of dates. You might need to adjust the slicer to use the DefaultStartDate column for the range but display the Calendar[Date] for user selection.