Date Slicer with fixed position

[Anonymous]

Hi guys, 

i have a date slicer on a report. I would like that when opening the report the position of the slicer is always beginning of the year (1.1.2023) until today. 

The slicer should not be limited to that date range. It should also be able to selecet dates earlier than 1.1.2023. It's just the position of the slicer is set on 1.1.2023.

It should basically look like this: 

Red line: position of the slicer

Yellow line: dates before the position of the slice should not be cut off

Thanks!

[AmiraBedh · Accepted solution]

In Power BI, setting a slicer's default position to a specific date while still allowing users to freely select dates earlier than that date can be a bit challenging. Currently, Power BI doesn't have a built-in option to achieve this specific behavior.

One possible workaround could be to create a separate table with a single date value (e.g., 1.1.2023) and use it as a filter for the visualizations while allowing users to freely interact with the original date slicer. However, this approach might not provide the exact behavior you are looking for.

If your scenario requires this specific behavior, you might consider submitting a feature request to the Power BI team or exploring custom visuals or other third-party tools that could offer more flexible date slicer options.