Combing Slicers

Copper Contributor

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"