Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic date range selection

Hi All,   Example:- If the user chooses the date range slicer 03/1/2022 - 04/01/2022, make the table show the same date range for the prior 3 years, how should I make it.   Need your help!   Th...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You can not default range slicer. You can use relative date slicer or a work around default column like

 

Year Type = Switch( True(),
year([Date])<= year(Today()) && year([Date])>= year(Today())-3,"Last 3 Years" ,
Format([Date],"YYYY")
)

 

 

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA