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.

MFelix's avatar
MFelix
Super User
6 years ago

Hi Narukkp ,

 

Assuming you only want to have a single selection on your day slicer correct?

 

Create a table with days for the slicer then add the following measure and use it on the filter of the visualization showing all values equal to 1:

Filter by day = IF(SELECTEDVALUE(Table[Day]) = SELECTEDVALUE(DaysSlicer[Day]) ||SELECTEDVALUE(Table[Day]) = "EveryDay" ; 1 ; 0)

 

This will only allow 1 selection of day otherwise will return a blank table.

  • Narukkp's avatar
    Narukkp
    Helper V
    6 years ago

    Hi,

    I required the Indidul day and everyday data. That means if i am selecting Monday then Monday & Every day related both need to show.

     

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Hi Narukkp ,

       

      In the formula I have provided when you select monday it will automatically return Monday and Everyday.

       

      my questions was in the sense if you need for example to select Monday and Tuesday and return monday tuesday and every day?

      • Narukkp's avatar
        Narukkp
        Helper V
        6 years ago

        Hi ,

        MFelix Thanks for your reply. I have follow the same above proces like created the separate table for day slicer and create the filter measure but my requirement is not achived. 

        For your question if i am selecting Monday & tuesday then i required Monday, Tuesday and Everydata.