Setting moving default start and end Date in power BI

Question

I have a power BI report that need A default start date of two weeks ago and end date of Today. However, I also want the user to select other date ranges from the slicer if they want. Is there a way I can achieve it with power BI slicer?

If yes How can I do it?

Why are there people here letting others think over their problems without being interested in the results? Is that some form of anti-social behavior? — Peter

Peter Peter · Accepted Answer · 2021-08-01T14:49:34

You need a second slicer to switch between your default date period (separate date table) and a custom date period.

Date Periods = 
UNION(
    ADDCOLUMNS(
        DATESBETWEEN('Calendar'[Date], TODAY() - 13, TODAY()),
        "Type", "Default"
    ADDCOLUMNS(
        CALENDAR(MIN('Calendar'[Date]),MAX('Calendar'[Date])),
        "Type", "Custom"
    )
)

Plus you need a measure to filter your first slicer depending on the selection.

Slicer Filter = 
IF(
    SELECTEDVALUE('Date Periods'[Type]) = "Custom",
    1,
    0
)

Setting moving default start and end Date in power BI

1 Answers