Hi again,
I have a question about Slicer. If I recall it correctly then a Slicer can only control data which is like within the same cache. Meaning it can only control data which is based on the same source - same Pivot Table.
Now I have a sheet showing two different sets of prices. One set contains daily prices and the other one contains hourly prices. Both are maintained within Excel Table followed by a Pivot Table which leads in both cases into a Pivot Chart. I created a Slicer based on the dates of the first data source (daily prices) but this one can't control the second data source (hourly prices chart).
Is there any way or trick I can use to let this Slicer control everything? On both data sources I work with the additional data format YYYY-MM to have the Slicer include years and months (followed your solution in my other thread
) so actually the dates are identical. I even created a second Slicer for the second data hoping there might be a way to let the first Slicer control the second one but unfortunaly I got stuck here as well.
So I really hope that you would have any idea/a solution for me!
Cheers
Tobias
P.S.: Let me know if you need my Excel workbook.
Hi Tobias,
Correct, Slicers can only control PivotTables that are from the same data source and share the same Pivot Cache.
You could possibly write some VBA code to read the selections from the first slicer and then filter the second PivotTable but I don't have anything I can refer you to. In session 5.08 of the Dashboard course I show you how you can use a Combo Box and Macro to control filtering on separate PivotTables, but this is not as slick as a Slicer.
Another option is to put all of your data into one big table and use that as your source data.
Or you can use Power Pivot and load both tables, plus a Date table. Then create relationships between the two tables and the date table to link them all together. Then you can create one or more PivotTables and control them all with one Slicer. However, you probably need to learn Power Pivot first as it's not as simple as just loading and pivoting.
Mynda
Hi Mynda,
while getting to the end of the course you tend to forget about the content of previous sessions. So yes, Combo Box is actually a good way to get tables which are based on multiple sources steered all together. 
Maybe Power Pivot is another nice way but first I have to finish one course before I start thinking about the next one.
Thanks a lot for your feedback!
Cheers
Tobias
I know there is a lot to take in. As you practice and implement more you'll recall the different techniques more easily.
I think it's a good idea to master one topic before moving on to the next. I recommend you master Power Query before Power Pivot.
Mynda
Thank you!
Cheers
Tobias
