slicer - set default value is current week

[hellgoingon]

Hi all,

I have table contain start-date is list of date. Now i drap&drop start-date into slicer and got below picture.

How can i do to setup default value for slicer is current week?

Example: when open report, 6/12/2017 and 6/18/2017 will be displayed as default in below image

[v-yulgu-msft]

Hi @hellgoingon,

Because the values of table column is always fixed, they won't be automatically changed everyday. Also, we are not able to add measures into a slicer.

To work around your requirement, you could create two measures and a calendar table as below:

Week start = TODAY()-WEEKDAY(TODAY(),2)+1
Week End = TODAY()-WEEKDAY(TODAY(),2)+7

Date Table = CALENDAR([Week start],[Week End])

Add 'Date Table'[Date] into slicer.

Best regards,
Yuliana Gu