Is it possible to have single selection radio buttons slicer that would filter by Today() - 7 days, Today() - 30 days and Today() - 60 days? So, to plot the last 7 days values, 30 days values or 60 days values. I'm able to single select by Quarters but instead of quarters use a range of days based on today's date? I tried filters but didn't get it to work.
Thank you for your help.
Date Periods =
UNION(
ADDCOLUMNS(
CALENDAR(TODAY() - 7, TODAY()),
"Period", "Last 7 days",
"Sort", 1
),
ADDCOLUMNS(
CALENDAR(TODAY() - 30, TODAY()),
"Period", "Last 30 days",
"Sort", 2
),
ADDCOLUMNS(
CALENDAR(TODAY() - 60, TODAY()),
"Period", "Last 60 days",
"Sort", 3
)
)
The result should look like this: