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")
nklueber
Copper Contributor
May 18, 2020
ExcelExciting
Thanks for the feedback, Faraz. I'll use the helper column approach.
Some sort of integration into the Timeline slicer would be great for future releases. The use of the slider bar makes it convenient and space friendly (keeps the Dashboard clean!).
Thanks again.