Forum Discussion

amir_mm's avatar
amir_mm
Helper III
2 years ago
Solved

Between date slicer - default start and end time

Hi, I’m using a between date slicer and have applied the measure "CurrentDay = 'Dim-Date'[Date] - TODAY()" with a page-level filter set to "less than or equal to 0" so that the default end date is a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi amir_mm ,

     

    You can try below formula to create calculated column and use it to page filter.

    CurrentDay = 
VAR StartDate = TODAY() - 7
RETURN
    IF('Dim-Date'[Date] >= StartDate && 'Dim-Date'[Date] <= TODAY(), 1, 0)

    Best Regards,
    Adamk Kong

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amir_mm ,

 

You can try below formula to create calculated column and use it to page filter.

CurrentDay = 
VAR StartDate = TODAY() - 7
RETURN
    IF('Dim-Date'[Date] >= StartDate && 'Dim-Date'[Date] <= TODAY(), 1, 0)

Best Regards,
Adamk Kong

 

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

amir_mm's avatar
amir_mm
Helper III
2 years ago

Thanks for the query. But as I mentioned in the other post and shown in the photo, I still want users to be able to move the slider all the way back to earlier years. So, when a user opens a report, the default view should be the last 7 days, but they should still have the ability to move the toggle back and forth.

  • kushanNa's avatar
    kushanNa
    Super User
    2 years ago

    looks like someone had mistakenly marked the wrong answer as the correct answer, maybe you might need to create a new post 😕