How to create more than one group that include the same value, using a slicer?

[GeorgeG]

Hi, I am looking to have a slicer that filters by multiple clients. This is simple enough, however, what if a group contains Clients that are in another Group?

For example,

Group 1: Alpha, Bravo, Charlie

Group 2: Delta, Echo

Group 3: Alpha, Charlie, Echo

I want to be able to use a drop down slicer that you can select from Group 1, 2 and 3. This is currently how I have the first two Groups setup, but how can I create the third:

Groups =

if(find("Alpha",Clients[Name],,-1)>0,"Group 1",

if(find("Bravo",Clients[Name],,-1)>0,"Group 1",

if(find("Charlie",Clients[Name],,-1)>0,"Group 1",

if(find("Delta",Clients[Name],,-1)>0,"Group 2",

if(find("Echo",Clients[Name],,-1)>0,"Group 2",

[v-gizhi-msft · Accepted solution]

Hi,

Please take following steps:

1)Create a group slicer table as below by Enter Data:

2)Try this measure:

Measure = 
SWITCH (
    SELECTEDVALUE ( 'Table 2'[Groups] ),
    "Group 1", IF ( SELECTEDVALUE ( 'Table'[Clients] ) IN { "Alpha", "Bravo", "Charlie" }, 1 ),
    "Group 2", IF ( SELECTEDVALUE ( 'Table'[Clients] ) IN { "Delta", "Echo" }, 1 ),
    "Group 3", IF ( SELECTEDVALUE ( 'Table'[Clients] ) IN { "Alpha", "Charlie", "Echo" }, 1 )
)

3)Apply this measure to the original table by setting measure=1.

  When selecting one value in group slicer, the result shows:

See my attached pbix file.

Best Regards,

Giotto

[Mariusz]

Hi @GeorgeG 

If you Alpha, Bravo, Charlie is a full customer name, not a part that you need to find then you can simply use Measure Option One else if Alpha, Bravo, Charlie is a text that you need to find within the customer name then Measure Option Two is the option for you.

Both Measures can be found on the attached.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

@GeorgeG , refer if this can help

Segmentation
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization