Group the same item into more than one group and use as a selector

[waltersbrf]

Hi all,

I have the following problem.

I have a dashboard with several charts that contain various calculations.

I would like to place a selector from a group of items in a dimension.

For example:
Item
A
B
C
D
E

I would like to group it like this:
Group 1 = A, B
Group 2 = A, B, C
Group 3 = D, E
Group 4 = A, B, C, D, E

That way I would like the selector to have the items grouped together.
And when choosing one of these groups, the entire dashboard would show the calculations based on that item group.

Thanks.

[hnguy71 · Accepted solution]

@waltersbrf ,

You would need to create a table similar to this:

And then add the grouping to your slicer to be able to get the calculations for these groups, and then of course, create a relationship back to your base table where you're getting the item id/name from.

[amitchandak]

@waltersbrf , You have to create one more table with multiple groups and need to have many to many join with that

Group item

1 A

1 B

2 A

And so on

Something similar done in this video - Single Select with Select All : https://youtu.be/plGqCEZRfXU