Forum Discussion

tebtim19's avatar
tebtim19
Helper IV
1 year ago

previous and nextday button

Hi is there anyone here know how to create a previous and next day button in power bi?  I have a date column with the format dd/mm/yyyy. In my power bi visual I'm currently using the date filter, bu...
Need Help
Tips and Tricks
audreygerred's avatar
audreygerred
Super User
1 year ago

Hi! For this you can use a button then assign it actions to go to another page or bookmark. If you have it take you to another page, you could have the page for today set to today's date. The page or bookmark for previous would have a relative date filter of is in the last 1 day:

For next (i.e. tomorrow) if would be is in the next 1 day:

 

tebtim19's avatar
tebtim19
Helper IV
1 year ago

Hi audreygerred thanks for this information. Unfortunately this filter will only base in the windows date. It will not work if for example I have opened a data and filter it with 31.12.2024 and then when I click previous date it should goes back to the date 30.12.2024 and then when I click it it will goes to 29.12.2024 same when I click next it will change to date forward.


 

 
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,

    Thanks for the solution audreygerred  offered, and i want to offer some more information for user to refer to.

    hello tebtim19 , based on your descriotion, it cannot set the button directly, you can consider to alternative solution, you can refer to the following solution.

    Create two tables

    Table 2 = {"Previous","Next"}
    Table 3 = GENERATESERIES(1,100,1)

    Then create a measure

    MEASURE =
SWITCH (
    SELECTEDVALUE ( 'Table 2'[Value] ),
    "Previous", MAX ( 'Table'[Date] ) - SELECTEDVALUE ( 'Table 3'[Value] ),
    "Next", MAX ( 'Table'[Date] ) + SELECTEDVALUE ( 'Table 3'[Value] )
)

    Then create two slicers, and put the value of table2 and table3 to them.

    Output

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.