Forum Discussion

Tiyani's avatar
Tiyani
Icon for Helper I rankHelper I
1 year ago
Solved

Relative date and Date slycer

Hello everyone,  I want my power BI report page to show the past 7 days by default (I've done this using relative date) but I also want the same report page to be filtered with a date slicer with ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    You'll need a column to distinguish what's within and beyond seven days. Use that column in a slicer. Please see attached pbix.

     

     

Tiyani's avatar
Tiyani
Icon for Helper I rankHelper I
1 year ago

Hi danextian

 Thank you for your reply but can you please explain more on how this would work?

danextian's avatar
danextian
Icon for Super User rankSuper User
1 year ago

You'll need a column to distinguish what's within and beyond seven days. Use that column in a slicer. Please see attached pbix.