Forum Discussion
create a custom slice filter
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.
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