Forum Discussion
create a custom slice filter
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.
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 SlicerSlicer = 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 directionRegards,SayaliIf this post helps, then please consider Accept it as the solution to help others find it more quickly.
1 Reply
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 SlicerSlicer = 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 directionRegards,SayaliIf this post helps, then please consider Accept it as the solution to help others find it more quickly.