Slicer date : force start and send selection due to current week

[Anonymous]

Hey,

Actually I'm using a date slicer, but I'd like to start and end date to be automaticly selected depending on the current week, but the user will still have the option to change thoose dates on the original scale.

For example, from

if we are the 2020/08/24 I want my default start and end date to be 2020/08/24 and 2020/08/30 :

[benabdillahr]

Hey,

Any luck with this? I am running to the same issue.

[v-deddai1-msft]

Hi @Anonymous ,

Would you please try to add a measure filter in your visual level filter ：

Measure = IF(WEEKNUM(MAX('Table'[Date]),2) = WEEKNUM(TODAY(),2),1,0)

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

Best Regards,

Dedmon Dai

[Anonymous]

Thank you @v-deddai1-msft , but this is not what I'm looking for, I want the min and max range of my slicer to be the same, I just want the selection of the start and end date to be updated :

[v-deddai1-msft]

Hi @Anonymous ,

Based on my test, it is not possible to meet your requirement currently.You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , You can not initialize date ranges using some function.

You can create a column in date table

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[Week Name]
) 

and use that in filter as this week

[Anonymous]

Thank you for your answer @amitchandak but I want the user to be still able to slice the date to whatever he wants between the initial min and max date.
I just need a preselection of beginning and end date corresponding to the current week.