Excel 2016 - Timeline and Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2688127%22%20slang%3D%22en-US%22%3EExcel%202016%20-%20Timeline%20and%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2688127%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I'm%20trying%20to%20use%20the%20timeline%20object%20to%20filter%20date%20columns%20in%20a%20pivot%20table%2C%20using%20microsoft%20excel%202016.%20The%20thing%20is%2C%20I%20was%20wondering%20if%20there%20is%20some%20keyboard%20command%20to%20edit%20the%20initial%20and%20final%20date%20in%20that%20object%2C%20so%20I%20don't%20need%20to%20change%20dates%20with%20the%20mouse%20cursor.%20I%20need%20that%20accessibility%20in%20this%20spreadsheet%2C%20so%20the%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPS.%3A%20English%20is%20not%20my%20native%20language%2C%20so%20there%20might%20be%20some%20writing%20mistakes.%20In%20the%20attached%20image%20some%20parameters%20are%20in%20portuguese%2C%20the%20translation%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Todos%20os%20per%C3%ADodos%22%20-%20all%20periods%3C%2FP%3E%3CP%3E%22Dias%22%20-%20days%3C%2FP%3E%3CP%3E%22Dez%20de%202020%22%20-%20December%2C%202020%3C%2FP%3E%3CP%3E%22Jan%20de%202021%22%20-%20January%2C%202021%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2688127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2693134%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20-%20Timeline%20and%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2693134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138464%22%20target%3D%22_blank%22%3E%40JoaoRodrigues%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EN%C3%A3o%20tenho%20certeza%20do%20que%20voc%C3%AA%20quer%20dizer.%3CBR%20%2F%3EAs%20datas%20no%20objeto%20Timeline%20s%C3%A3o%20baseadas%20no%20conjunto%20de%20dados.%3CBR%20%2F%3EN%C3%A3o%20tenho%20certeza%20de%20como%20sua%20tabela%20din%C3%A2mica%20se%20baseia%3CBR%20%2F%3E(Cl%C3%A1ssico%20vs%20Power%20Pivot%20usando%20modelo%20de%20dados)%3CBR%20%2F%3Eprovavelmente%20%C3%A9%20poss%C3%ADvel%20se%20voc%C3%AA%20usou%20a%20%C3%BAltima%20e%20n%C3%A3o%20a%20primeira%20usando%20uma%20tabela%20de%20calend%C3%A1rio%20que%20tem%20uma%20rela%C3%A7%C3%A3o%20com%20a%20tabela%20de%20transa%C3%A7%C3%A3o%20(conjunto%20de%20dados%20real)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi! I'm trying to use the timeline object to filter date columns in a pivot table, using microsoft excel 2016. The thing is, I was wondering if there is some keyboard command to edit the initial and final date in that object, so I don't need to change dates with the mouse cursor. I need that accessibility in this spreadsheet, so the question.

 

PS.: English is not my native language, so there might be some writing mistakes. In the attached image some parameters are in portuguese, the translation is:

 

"Todos os períodos" - all periods

"Dias" - days

"Dez de 2020" - December, 2020

"Jan de 2021" - January, 2021

1 Reply

@JoaoRodrigues 

 

Não tenho certeza do que você quer dizer.
As datas no objeto Timeline são baseadas no conjunto de dados.
Não tenho certeza de como sua tabela dinâmica se baseia
(Clássico vs Power Pivot usando modelo de dados)
provavelmente é possível se você usou a última e não a primeira usando uma tabela de calendário que tem uma relação com a tabela de transação (conjunto de dados real)

 

https://youtu.be/e-CFYi52gpc

Download Files: https://people.highline.edu/mgirvin/AllClasses/218_2016/218Excel2016.htmIn this video learn about:1. (00:16) Introduction to Entire Project, ...