Forum Discussion
How to get a Single Timeline with Pivot Tables from different Data Sources?
Hii, @community My present work is to make a Dashboard using 7 Different Excel files, I have connected these sheets through PowerPivot DataModel and made the required PivotTable. There are 3-4 col...
NikSat Since you also sent me a direct message I'll summarize the answer I gave you there.
Similar to the unique line item table, you need to create a Calendar table with unique dates for all dates that exist in your model. Relate all tables to the Calendar table based on the date and use the date from the Calendar table in your pivot tables. Then the slicer should work.
- Hi Riny, I tried the method you mentioned, but it's not working if I have one timeline for each pivot table. Then is there a way to connect these timelines internally so that if I change one timeline, others should also change automatically?
Is it possible?Similar question in the link below:
