powerpivot question

bionicle

Board Regular
Joined
Apr 23, 2009
Messages
168
Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
I've started to use power pivots and I'm finding it very frustrating :banghead:
<o:p></o:p>
The problem I'm having is as follows:<o:p></o:p>
I have several worksheets that I have imported via power pivot window which works fine. When I bring the pivot into excel and create a slicer for that table all the data changes as it should do but when I create a second / third table and try to link all together nothing happens?
<o:p></o:p>
I have tried to build the relationship build between them by using pivot table connections but it still doesn’t work.
<o:p></o:p>
I’ve also tried to use a second slicer and linking them but I don’t want two slicers identical to each other and when I delete it nothing works.
<o:p></o:p>
Help is needed before the laptop goes out the window.....
<o:p></o:p>
Thanks in advance....<o:p></o:p>
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

MD610

Board Regular
Joined
Feb 7, 2012
Messages
188
Are you just trying to link a slicer to more than one pivot?

If so, then you can do one of 2 things:

1. Select the slicer, then go to the Slicer Tools tab that appears in the ribbon. From there, go to PivotTable Connection and select the pivots that you want connected to the slicer.

2. Alternatively, you could select the Pivot first, then go to the Options tab that appears under PivotTable Tools. Go to Insert Slicer>Slicer Connections and select the slicers you want to connect the pivot.
 

bionicle

Board Regular
Joined
Apr 23, 2009
Messages
168
Hi MD610

Tried both these ways but it doesn't work, I've even created a connection between them and all worksheets have a column labeled the same (date) to give them a commonality.

At a loss...
 

MD610

Board Regular
Joined
Feb 7, 2012
Messages
188
Are your 2 (or 3) additional Pivots using the same data table as the first Pivot?

Is the field being used for the slicer in the same data table as the pivot fields in each table? If not, have you double checked the relationships you created between different data tables in the PowerPivot window?

Depending on your data model and how your pivot is structured, you don't always end up with the results you think you will at first. Sometimes, I find it easier to add a column to the data table that has the primary data I will be using in my pivot using the RELATED function (pretty much works like a VLOOKUP from regular excel). Then I just "bring in" the columns I need from the other table so that all my pivot fields and slicers are essentially coming from a single table. This step can sometimes simplify things as opposed to mixing and matching fields/slicers from different tables.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,740
Messages
5,524,557
Members
409,584
Latest member
Devil_717

This Week's Hot Topics

Top