Forum Discussion

mebab's avatar
mebab
Icon for Microsoft Employee rankMicrosoft Employee
11 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

Create a calculated column:

Days_From_Today = IF('Date'[DateId] <= TODAY(), 0 - DATEDIFF([DateId], TODAY(), DAY),DATEDIFF(TODAY(), [DateId], DAY))

 

then use it to set your filter as "between -12 and 0". this will then always be the last two weeks.