Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Add default values for date slicer with style "between"

I would like to be able to enter default values ​​that change depending on the period and without it "locking" the user to the default dates.
For example: I would like my report to always display data from the beginning of the current year to the end of the current year and yet allow the user to switch to see the data for 2024 or only certain months in 2023 for example.
And if we reached 2026 I would like the default dates to be between 01-01-2026 and 31-12-2026

Status: New
Comments
alecade
New Member
It's already possible... You've to use a slicer (or filter pane) with the field 'Calendar'[Date] and in Format options set "Relative Date"
orbe
Advocate IV
Dear @alecade You didn't understand my thoughts and the need. The need is to allow each user to choose the dates they want. It could be a week, two weeks, two days or from July 2023 to July 2024. If I use relative date, unfortunately it won't allow this flexibility for the user. However, I would like to have default dates from the beginning of the year to the end of the year.