Forum Discussion

hellgoingon's avatar
hellgoingon
Helper II
9 years ago

slicer - set default value is current week

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

 

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    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