Slicer selection data

[Narukkp]

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 way I am selecting Tuesday then I need to show the Tuesday(B) and Every Day(D,E,F) related data. Could you please suggest me how to achieve this scenario

[v-jayw-msft]

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.

[v-jayw-msft · Accepted solution]

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.

[Narukkp]

Thank you @v-jayw-msft . Perfect it is working as expected.. 

[MFelix]

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]

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]

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]

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.