Home

Slicer data

%3CLINGO-SUB%20id%3D%22lingo-sub-110911%22%20slang%3D%22en-US%22%3ESlicer%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-110911%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20series%20of%20slicers%20on%20a%20sheet%20to%20easily%20show%20the%20different%20column%20values%20for%20one%20record.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20sheet%20has%20a%20pivot%20table%20so%20all%20the%20data%20is%20linked%2C%20however%20the%20rest%20of%20the%20data%26nbsp%3Bare%20on%20different%20sheets%20and%20not%20in%20pivot%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20the%20slicers%20based%20on%20pivots%20show%20data%2C%20it%20isn't%20linked%20to%20non-pivot%20based%20ones%20so%20when%20I%20select%20a%20record%2C%20only%20the%20pivot%20slicers%20will%20filter%20and%20not%20the%20others.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20create%20a%20relationship%20between%20relevant%20columns%20on%20power%20pivot%20but%20keep%20getting%20an%20error%20message%20stating%20there%20are%20blank%20fields%20when%20there%20isnt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20link%20them%20so%20all%20slicers%20are%20filtered%20together%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-110911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-111495%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111495%22%20slang%3D%22en-US%22%3E%3CP%3EI%20gave%20in%20and%20just%20created%20a%20main%20pivot%20table%20with%20all%20columns%2C%20and%20then%20separate%20PV%20tables%20with%20selected%20columns.%20My%20relevant%20slicers%20then%20were%20based%20on%20each%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-111229%22%20slang%3D%22en-US%22%3ERe%3A%20Slicer%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-111229%22%20slang%3D%22en-US%22%3ECheck%20if%20all%20columns%20have%20headers%2C%20there%20could%20be%20a%20way%20to%20do%20this%2C%20could%20you%20share%20each%20table%20headers%20and%20what%20you%20want%20to%20filter%20with%20each%20slicer%3F%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I'm creating a series of slicers on a sheet to easily show the different column values for one record.

 

One sheet has a pivot table so all the data is linked, however the rest of the data are on different sheets and not in pivot tables.

 

Though the slicers based on pivots show data, it isn't linked to non-pivot based ones so when I select a record, only the pivot slicers will filter and not the others.

 

I've tried to create a relationship between relevant columns on power pivot but keep getting an error message stating there are blank fields when there isnt.

 

How can I link them so all slicers are filtered together?

2 Replies
Highlighted
Check if all columns have headers, there could be a way to do this, could you share each table headers and what you want to filter with each slicer?
Highlighted

I gave in and just created a main pivot table with all columns, and then separate PV tables with selected columns. My relevant slicers then were based on each table.

Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Pulling data from one tab to another
krysphares in Excel on
6 Replies