Forum Discussion
Filter setting default on current week/month
- 5 years ago
Anonymous
You can add a column to your date table along these lines.
Week = VAR _Today = TODAY() RETURN IF ( YEAR ( [Date] ) = YEAR ( _Today ) && WEEKNUM ( [Date] ) = WEEKNUM ( _Today ), "Current Week", ***** whatever you normally show for month/week goes here ***** )Then you put that column in your slicer and select "Current Week". As the meaning of current week changes the date table will update and your report will shift with it.
- Anonymous5 years ago
Anonymous
You can create a weeknumber column, and then just use the TOP N filter on the visual with this weeknumber column. So the visual will displays the latest week data, and also allows you select other weeks on the slicer.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Anonymous
You can add a column to your date table along these lines.
Week =
VAR _Today = TODAY()
RETURN
IF ( YEAR ( [Date] ) = YEAR ( _Today ) &&
WEEKNUM ( [Date] ) = WEEKNUM ( _Today ),
"Current Week",
***** whatever you normally show for month/week goes here *****
)
Then you put that column in your slicer and select "Current Week". As the meaning of current week changes the date table will update and your report will shift with it.