Forum

Notifications
Clear all

Is there a time slicer for week, besides date, month, quarter and year?

2 Posts
2 Users
0 Reactions
909 Views
(@lyani)
Posts: 1
New Member
Topic starter
 

currently I insert a column, and look up date with week name... Is there any other way? Thanks.

Lalu

 
Posted : 04/07/2020 12:49 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Lalu,

Welcome to our forum! You can group the dates in the PivotTable by week i.e. right-click the date in the PivotTable > group by > days and choose 7 days. Then you can insert a Slicer for the date field which will give you the week ranges.

Mynda

 
Posted : 04/07/2020 6:47 am
Share: