How to group values in a slicer

[AishwaryaS]

Hi,

I have a slicer with a list of Product ID (eg) : TV, FRIDGE, AC, WASHER, BAG, BOOKS, PENCIL etc

I want to group the values and have only the grouped header in the slicer

HOME APPLIANCES which should include (TV, FRIDGE, AC, WASHER) and

SCHOOL which should include (BAG, BOOKS, PENCIL)

My output slicer should contain only HOME APPLIANCES AND SCHOOL.

Please let me know how to achieve this.

[Samarth_18 · Accepted solution]

Hi @AishwaryaS ,

The best which I could suggest is to create a new column with switch condition as below and use it in the slicer.:-

column =
SWITCH (
    TRUE (),
    [product list] IN { "TV", "FRIDGE", "AC", "WASHER" }, "HOME APPLIANCES ",
    [product list] IN { "BAG", "BOOKS", "PENCIL" }, "SCHOOL"
)