Power BI Dax Expression Help - Setting default slicer between dates

0
votes

Power Bi report uses a date slicer (between) - As a default I want it to set the first date in the slicer as Monday (last week) and the last date as Friday (last week). I dont want this to be a relative date but always must be the previous Mon-Fri. I have a column in my data set that tells me which one is the 'Previous Week' as a text field. I dont know how to use this to set a default slicer value. But i also want to make sure the user can change the slicer dates and it changes as per the user request.

Example today is 01/09/2020

I want my default slicer date as : 24/08/2020 - 28/08/2020

I have two measures which gives me by last week dates:

DefaultSD = MINX( FILTER(Data, [WeeksFilter] = "Previous Week Only"),[Date])  

DefaultED = MAXX( FILTER(Data, [WeeksFilter] = "Previous Week Only"),[Date])

I assume this is possible using a DAX expression but dont know how to create this expression to populate these default values.

Please note the data is refreshed up until 01/09/2020 so there is currently data for this week but i dont want this to included in the default slicer on report load

1
powerbidax
I found no option for setting Slicer default value. This morning I was trying for a much similar implementation but no luck. You can calculate start and end dates using DAX, but can not set them to Slicer as a selected start and end date. – mkRabbani

1 Answers

2
votes

You can't set slicer defaults yet but this can be achieved with relative date filtering.

Select date in the last 1 calendar week:

enter image description here