Forum Discussion

mebab's avatar
mebab
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Default value for filters

I have a report with a date filter in it. Is it possible to give default values to them (preferably pogrammatically) such that every time the report loads, the report is shown for the default values,...
celcius's avatar
celcius
Frequent Visitor
9 years ago

If yu have a date table set a calculated column as

Days_From_Today = IF([DateId] <= TODAY(), 0 - DATEDIFF([DateId], TODAY(), DAY),DATEDIFF(TODAY(), [DateId], DAY))
where [DateId] is the date column in your date table. This will allow you to set a filter on Days_From_Today of Between -12 and 0.

You can apply this column to your data if you don't have a date table.