Forum Discussion
Creating buttons to go back and forth a week
How do i create this:
Two buttons, one that lets me go back 1 week and one that lets me go forward 1 week, while displaying the calender week in the middle?
Hi LukasPardon ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a calculated column.
Week = WEEKNUM('Table'[date],2)Refer : WEEKNUM function (DAX) - DAX | Microsoft Learn
(3) Use this calculated column as a slicer and format it as shown below.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
LukasPardon , Create slicer as tile or orientation as horizontal. and give space for only 1 title
when you move
What data would i use in the values field? I have a lot of data that uses individual dates (DD,MM,YYYY) and i somehow need to connect it to the slicer, so that i knows what dates correspond to what weeks.
Hi LukasPardon ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a calculated column.
Week = WEEKNUM('Table'[date],2)Refer : WEEKNUM function (DAX) - DAX | Microsoft Learn
(3) Use this calculated column as a slicer and format it as shown below.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
