Forum Discussion
Modify Slicer Date
Hi Anonymous ,
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.
Anonymous & bhanu_gautam thank you. I used this option in the screen shot below to get what I am looking for
Anonymous , 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.