cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hellgoingon
Helper II
Helper II

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

 

6-16-2017 12-15-26 PM.png

1 REPLY 1
v-yulgu-msft
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors