How to Add a Search Box to a Slicer in Excel - while using Tables

%3CLINGO-SUB%20id%3D%22lingo-sub-1939409%22%20slang%3D%22en-US%22%3EHow%20to%20Add%20a%20Search%20Box%20to%20a%20Slicer%20in%20Excel%20-%20while%20using%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939409%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20to%20create%20a%20slicer%20on%20the%20visualization%20with%20a%20search%20box.%20However%2C%20as%20I%20do%20not%20want%20the%20data%20to%20be%20summarised%2C%20I%20have%20imported%20my%20data%20as%20a%20Table%20instead%20of%20a%20Pivot%20Table%20(which%20means%20I%20am%20unable%20to%20duplicate%20the%20Table%2C%20report%20connections%20etc).%20This%20has%20resulted%20in%20me%20not%20being%20able%20to%20re-create%20what%20the%20tutorial%20below%20has%20shown%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20referred%20to%20the%20video%20below%20prior%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D95_dIb8PMpc%26amp%3Bfeature%3Demb_title%26amp%3Bab_channel%3DExcelCampus-Jon%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D95_dIb8PMpc%26amp%3Bfeature%3Demb_title%26amp%3Bab_channel%3DExcelCampus-Jon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20idea%20how%20I%20can%20add%20a%20search%20box%20to%20a%20slicer%20while%20using%20Tables%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1939409%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1939484%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20to%20Add%20a%20Search%20Box%20to%20a%20Slicer%20in%20Excel%20-%20while%20using%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939484%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F885269%22%20target%3D%22_blank%22%3E%40zyc93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETake%20a%20look%20here%2C%20maybe%20this%20information%20will%20help%20you.%20It's%20just%20a%20suggestion%2C%20if%20that's%20not%20what%20you%20have%20in%20mind%2C%20please%20just%20ignore%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd%20worksheet%20data%20to%20a%20Data%20Model%20using%20a%20linked%20table%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-worksheet-data-to-a-data-model-using-a-linked-table-d3665fc3-99b0-479d-ba09-a37640f5be42%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fadd-worksheet-data-to-a-data-model-using-a-linked-table-d3665fc3-99b0-479d-ba09-a37640f5be42%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWish%20you%20a%20nice%20day.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1941431%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Add%20a%20Search%20Box%20to%20a%20Slicer%20in%20Excel%20-%20while%20using%20Tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1941431%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F885269%22%20target%3D%22_blank%22%3E%40zyc93%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20trick%20works%20only%20with%20PivotTable%2C%20not%20sure%20that%20something%20similar%20could%20be%20done%20for%20Tables.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

 

I wish to create a slicer on the visualization with a search box. However, as I do not want the data to be summarised, I have imported my data as a Table instead of a Pivot Table (which means I am unable to duplicate the Table, report connections etc). This has resulted in me not being able to re-create what the tutorial below has shown me.

 

I have referred to the video below prior:

https://www.youtube.com/watch?v=95_dIb8PMpc&feature=emb_title&ab_channel=ExcelCampus-Jon 

 

Does anyone have any idea how I can add a search box to a slicer while using Tables?

Thank you in advance. 

Learn how to add a search box to a slicer to quickly filter pivot tables, pivot charts, or Excel Tables.Click here to download the files: http://www.excelcam...
4 Replies

@zyc93 

Take a look here, maybe this information will help you. It's just a suggestion, if that's not what you have in mind, please just ignore it.

 

Add worksheet data to a Data Model using a linked table

https://support.microsoft.com/en-us/office/add-worksheet-data-to-a-data-model-using-a-linked-table-d...

 

Wish you a nice day.

 

Nikolino

I know I don't know anything (Socrates)

@zyc93 

This trick works only with PivotTable, not sure that something similar could be done for Tables.

Hi Nikolino,

I've looked at the document but that wasn't really what I was looking for. Thank you for contributing still.
Hi Sergei,

Thank you for your comment. I can't seem to do that after messing around with various functions.