Forum Discussion

GeorgeG's avatar
GeorgeG
Icon for Helper I rankHelper I
6 years ago
Solved

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

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...
  • v-gizhi-msft's avatar
    6 years ago

    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