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...
Need Help
  • 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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Narukkp ,

 

Have your problem be solved? Please consider accept the answer as a solution if it worked.

 

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.