Date slicer default to the current week

[BishwaR]

I have a date table and I want the date slicer to default to the current week when I open the report so that the data load would be minimum.

Can this be achieve without creating the physical week column just by writing a DAX.

Please help

[v-yiruan-msft · Accepted solution]

Hi @BishwaR ,

Please refer the method in the following thread to get it:

slicer - set default value is current week

Or you can create a relative date slicer to manually set the selections with current week:

Creating a relative date slicer and filter in Power BI

Best Regards