Forum Discussion
Solved
Date Filter
My report deals with 3 months before and 3 months after with no specific date to make the report automatic. Is there a date filter for that. as relative filter only consist of is in the next, in the...
AileenIsagani , Create a column in date table and use it in slicer of page level filter
if([Date]>= eomonth(today(),-4)+1 && [Date]<= eomonth(today(),3),"Three in Past and three next", "Other months")
You can try "preselected slicer" custom slicer, that will allow measure to default the value
amitchandak
Super User
Super UserAileenIsagani , Create a column in date table and use it in slicer of page level filter
if([Date]>= eomonth(today(),-4)+1 && [Date]<= eomonth(today(),3),"Three in Past and three next", "Other months")
You can try "preselected slicer" custom slicer, that will allow measure to default the value