Forum Discussion

Copper Contributor

May 10, 2022

How to have items belong to multiple different categories and then be able to filter.

I'm trying to create a database of different pet foods. I want to be able to add multiple categories that belong to one 'group' to each product then filter using those categories. Most products ar...

excel

Patrick2788

Silver Contributor

May 10, 2022

You might consider tabling the data and then adding a slicer (or two).

https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d?msclkid=557d31b2d06a11ecb8b74e1c2f33f825

Another option is to create a pivot table (The data would have to be un-pivoted with PowerQuery first).