Custom Slicer based on Grouped Cell Values in a column

[Anonymous]

Hello,

I am trying to create custom slicers that allow me to select a "category" instead of a cell value. 

This is what I have currently:

a	b	c
a1	b1	c1
a2	b2	c2
a3	b3	c3
a4	b4	c4
a5	b5	c5
a6	b6	c6

Suppose b1, b2, b5 belong to "Category 1", b3 and b6 belong to "Category 2", and b4 is "Category 3". I want to create a slicer that has 3 options: Categories 1, 2, and 3, such that it filters my table based on the selected category/categories. 

For example, if I select Category 1, the output should be: 

a	b	c
a1	b1	c1
a2	b2	c2
a5	b5	c5

How can I achieve this?

Thank you. Really appreciate your help!

[Irwan · Accepted solution]

hello @Anonymous 

please check if this accomodate your need.

1. create a calculated column for categories.

Category =

IF(

    RIGHT('Table'[a],1)="1"||

    RIGHT('Table'[a],1)="2"||

    RIGHT('Table'[a],1)="5"||

    RIGHT('Table'[b],1)="1"||

    RIGHT('Table'[b],1)="2"||

    RIGHT('Table'[b],1)="5"||

    RIGHT('Table'[c],1)="1"||

    RIGHT('Table'[c],1)="2"||

    RIGHT('Table'[c],1)="5",

    "Category 1",

IF(

    RIGHT('Table'[a],1)="3"||

    RIGHT('Table'[a],1)="6"||

    RIGHT('Table'[b],1)="3"||

    RIGHT('Table'[b],1)="6",

    "Category 2",

    "Category 3"

))

2. plot your data in table visual and the category column in slicer.

Hope this will help you.

Thank you.

[Anonymous]

Yes, this worked perfect. Thank you so much!

[Irwan]

hello @Anonymous 

glad to be a help.

Thank you.