Home

Combing Slicers

%3CLINGO-SUB%20id%3D%22lingo-sub-908633%22%20slang%3D%22en-US%22%3ECombing%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-908633%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20my%20database%20of%20contacts%20categorizes%20the%20contacts%20across%2020%20topics%20(sports%2C%20fashion%2C%20tech%2C%20etc.).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20slicers%20for%20each%20of%20these%20topics%20for%20easy%20filtering%2C%20but%20since%20they%20are%20in%20different%20columns%2C%20I%20have%2020%20different%20slicers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20merge%20these%2020%20slicers%20into%20one%20%22topics%22%20slicer%20that%20shows%20all%20categories%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%2C%3C%2FP%3E%3CP%3EElie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-908633%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESlicers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-911023%22%20slang%3D%22en-US%22%3ERe%3A%20Combing%20Slicers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-911023%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412714%22%20target%3D%22_blank%22%3E%40elieraflowitz%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20understand%20you%20correctly%2C%20you%20need%20to%20rename%20your%20third%20column%20in%20the%20blue%20section%20to%20%22Topic%22%20and%20then%20put%20the%20topic%20name%20for%20each%20entry%20in%20that%20one%20column.%20Then%20you%20can%20add%20one%20slicer%20that%20has%20all%20the%20available%20topics%20and%20can%20display%20all%20entries%20for%20e.g.%20%22Beer%22.%20Or%20select%20multiple%20topic%20to%20display%20all%20on%20e.g.%20%22Beer%22%20and%20%22Food%20%26amp%3B%20Beverages%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
elieraflowitz
Frequent Visitor

Hi, my database of contacts categorizes the contacts across 20 topics (sports, fashion, tech, etc.).

 

I have slicers for each of these topics for easy filtering, but since they are in different columns, I have 20 different slicers.

 

Is there a way to merge these 20 slicers into one "topics" slicer that shows all categories?

 

TIA,

Elie

1 Reply

@elieraflowitz 

If I understand you correctly, you need to rename your third column in the blue section to "Topic" and then put the topic name for each entry in that one column. Then you can add one slicer that has all the available topics and can display all entries for e.g. "Beer". Or select multiple topic to display all on e.g. "Beer" and "Food & Beverages"

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies