create a custom slice filter

[Portrek]

hello everyone. I have a question..

My data is divided into 8 types (T1, T2, T3, T4, T5, T6, T7, T8) and these types have a second division by grouping these "TS" forming by 2 groups (G1 and G2) which are marked in another column.

What I would like to do would be a filter that contemplated all the items the 8 types "t's" + the 2 groups "G's", forming a single full filter according to the following image so that I showed the individual values of the "TS" The accumulated "G"

Is there any way to do this? Join the ratings of the two columns in a single filter?

Thanks for advanced.

[sayaliredij · Accepted solution]

You can do this in following way

1. Create New Column in your table which contains T1, G1 assignment

2. I am naming column with T1, T2, T3 information as category and G1,G2 information as Group for referance

3. New Column will be 

You can do this in following way

1. Create New Column in your table which contains T1, G1 assignment

2. I am naming column with T1, T2, T3 information as category and G1, G2 information as Group for reference

3. New Column will be as follows

You can do this in following way

1. Create New Column in your table which contains T1, G1 assignment

2. I am naming column with T1, T2, T3 information as category and G1, G2 information as Group for reference

3. New Column will be as follows

CategoryGroup = COMBINEVALUES("|",Category[Category],Category[Group])

4. Create new table called Slicer 

Slicer = DISTINCT(UNION(SELECTCOLUMNS(Category,"Selection",Category[Category],"CategoryGroup",Category[CategoryGroup]),SELECTCOLUMNS(Category,"Selection",Category[Group],"CategoryGroup",Category[CategoryGroup])))

5. Make the connection between slicer and category table using category group. and make sure its both direction

Regards,

Sayali

If this post helps, then please consider Accept it as the solution to help others find it more quickly.