Pivot : How to 1 TimeLine Work into 2 Pivot With Different Data Set/Source

[muhammad susanto]

hi all..
i have 1 worksheet contains 2 pivot table with different data set (sheet e.g data_1 and data_2.
i want to use 1 TimeLine for2 pivot but not working, the table have connection..
how to make 1 Timeline working in 2 pivot with different data set/data source.
i'm stuck about this..

this my link file

Meet Google Drive – One place for all your files

Google Drive is a free way to keep your files backed up and easy to reach from any phone, tablet, or computer. Start with 15GB of Google storage – free.

drive.google.com

any help thank in advance..
.sst

 

[mart37]

You can use Power Pivot. When the tables have a connection they are also loaded in the data model of Power Pivot.
When you create your pivot tables in Power Pivot you can use one timeline.

 

[muhammad susanto]

You can use Power Pivot. When the tables have a connection they are also loaded in the data model of Power Pivot.
When you create your pivot tables in Power Pivot you can use one timeline.

Please, can you show me use power pivot , maybe use formula etc.. Im new bie about power query

 

[mart37]

Go to the tab POWER PIVOT - MANAGE
In Power Pivot are two tabs with your tables.
Go to the first table.
Make a new pivot table with START - PIVOT TABLE - PIVOT TABLE. Make the pivot table as same as your first created pivot table.
Go to the second table.
Make a new pivot table with START - PIVOT TABLE - PIVOT TABLE. Make the pivot table as same as your second created pivot table.
Now you can make a timeline for both pivot tables.

 

[muhammad susanto]

Go to the tab POWER PIVOT - MANAGE
In Power Pivot are two tabs with your tables.
Go to the first table.
Make a new pivot table with START - PIVOT TABLE - PIVOT TABLE. Make the pivot table as same as your first created pivot table.
Go to the second table.
Make a new pivot table with START - PIVOT TABLE - PIVOT TABLE. Make the pivot table as same as your second created pivot table.
Now you can make a timeline for both pivot tables.

hi mart37, i have do what your suggestion but still not work, only 1 TimelIne can work the other not work.
All table have connected and report connection too but show information "Realtionship between table may be needed ...."
how to fix it?
or someone would help me out?
note:
i have use Power Pivot in Ms Excel 2013 Pro Plus
2 Pivot in different data sources not single data source/set

 

[mart37]

In your first post you said: the table have connection..
I thought a connection through a relation.
In Power Pivot on the tab Design you can create a relation.