Forum Discussion

Copper Contributor

May 14, 2020

Solved

Pivot Timeline - calendar weeks

Hello, Is it possible to change the default intervals on the pivot Timeline? Our company operates many KPIs on a weekly basis, and it would be great if calendar weeks could be a setting in the Time...

excel

ExcelExciting
May 15, 2020
hi nklueber,

best to my knowledge there no weeks timeline slicer, what I can suggest you to make helper column and generate week number and drag that column as slicer in your pivot table.

below formula to construct year with week number
=YEAR(A2)&"-"&TEXT(WEEKNUM(A2,2),"00")

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

ExcelExciting

MVP

May 15, 2020

hi nklueber,

best to my knowledge there no weeks timeline slicer, what I can suggest you to make helper column and generate week number and drag that column as slicer in your pivot table.

below formula to construct year with week number

=YEAR(A2)&"-"&TEXT(WEEKNUM(A2,2),"00")

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

danstorch

Copper Contributor

Jul 05, 2023

The helper column works, but it requires selecting and unselecting many items depending on how large the timeline is. I'd suggest a value-based help column, so you can filter using "greater than" or "between":
=VALUE(YEAR(A2)&TEXT(WEEKNUM(A2,2),"00")