Creating buttons to go back and forth a week

[LukasPardon]

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?

[amitchandak]

@LukasPardon , Create slicer as tile or orientation as horizontal. and give space for only 1 title

when you move

[LukasPardon]

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.

[Anonymous · Accepted solution]

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.