Forum Discussion

Narukkp's avatar
Narukkp
Helper V
6 years ago
Solved

Slicer selection data

Hi Team, I have data below format. My requirement is I have one slicer called Day and if I am selecting Monday in slicer then I need to show the Monday(A) & Every Day(D,E,F) related data and same wa...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Narukkp ,

     

    Please check the following steps.

    1# Create a calculated table and use it as silcer.

    Table 2 = DISTINCT('Table'[day])

     2# Create the visual you want and create a measure then add it to the visual level filter = is not blank .

    Measure =
    IF (
        NOT ( ISFILTERED ( 'Table 2'[day] ) ),
        1,
        IF (
            SELECTEDVALUE ( 'Table 2'[day] ) = "everyday",
            1,
            IF (
                SELECTEDVALUE ( 'Table'[day] ) = "everyday"
                    || SELECTEDVALUE ( 'Table'[day] ) = SELECTEDVALUE ( 'Table 2'[day] ),
                1,
                BLANK ()
            )
        )
    )

     Result would be shown as below.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.