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.
alecade
New Member
@orbe mmm....in the same page putting multiple Date slicer in multiple forms... (weeks slicer, dates between slicer, etc..)?
orbe
Advocate IV
Once again, you didn't understand what I meant. I'll explain it again, and if you still don't understand, just don't vote. The goal is to create a single slicer ("between" style) with the ability to set variable default dates. The user will still have the ability to change the default dates. For example, a filter where the start date is the first day of the month and the end date is today.