topic Re: Custom Slicer based on Grouped Cell Values in a column in DAX Commands and Tips

Custom Slicer based on Grouped Cell Values in a column

Anonymous — Tue, 16 Jul 2024 18:12:52 GMT

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!

Re: Custom Slicer based on Grouped Cell Values in a column

Irwan — Tue, 16 Jul 2024 21:08:59 GMT

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.

Re: Custom Slicer based on Grouped Cell Values in a column

Anonymous — Wed, 17 Jul 2024 15:25:52 GMT

Yes, this worked perfect. Thank you so much!

Re: Custom Slicer based on Grouped Cell Values in a column

Irwan — Wed, 17 Jul 2024 21:14:46 GMT

hello Anonymous

glad to be a help.

Thank you.