Forum Discussion
Tiyani
Helper I
Helper IRelative 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 ...
You'll need a column to distinguish what's within and beyond seven days. Use that column in a slicer. Please see attached pbix.
danextian
Super User
Super UserHi Tiyani
In your calendar table, you will need to create a column that distguishes which dates are within and beyond seven days with a reference to a specific date - today or max transaction date. An example calculated colum would be:
VAR ReferenceDate =
TODAY () --or MAX(datatable[date])
RETURN
--includes the reference date and 6 days earlier for a total of 7 days
IF (
CalendarTable[Date]
>= TODAY () - 6,
"Past 7 days",
"Beyond 7 days"
)
