Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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"
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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"
)
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin