Slicer Value change for only one button

[jteague]

I have a slicer in my dashoboard 'Session' with different lengths of time:

Session

15-week

10-week, early

10-week, late

7-week, early

7-week, late

5-week, early

5-week, late

Dynamic w/o DE

For the top 7 buttons I just need them slicer to act normal and disagrregate the data based on the values within the session column.

For the last button 'Dynamic w/o DE' in need the slicer to only display the values if a different column 'DE' = 'No'. Thanks in adavance.

[Bibiano_Geraldo]

Hi @jteague ,
Create a Measure to Check for 'Dynamic w/o DE':

Session_Filter =
IF(
    SELECTEDVALUE('Session'[Session]) = "Dynamic w/o DE", 
    IF(
        SELECTEDVALUE('DE'[DE]) = "No", 
        1, 
        0
    ), 
    1
)

This measure checks whether the Session is "Dynamic w/o DE" and whether DE equals "No". If both conditions are met, the result is 1 (indicating that the data should be displayed). If not, the result is 0 (meaning the data should not be shown).

For each visual where you want this logic to apply, drag the Session_Filter measure to the Visual Level Filters and set it to 1.

[jteague]

Thanks for the quick reply. I think I followed your directions correctly but it removed "Dynamic w/o DE" from the slicer completely. Thanks.

[Anonymous]

Hi @jteague 

Thanks for the reply from Bibiano_Geraldo .

I created a sample data to test it for your reference:

1. Create a calculated table as follows

Slicer = VALUES('Table'[Session])

2. Create a calculated column as follows

IsDyn = IF([Session] = "Dynamic w/o DE" && [DE] = [No], 1, 0)

3. Create a measure as follows

SelectedValue = 
IF (
    SELECTEDVALUE ( Slicer[Session] ) = BLANK (),
    1,
    IF (
        SELECTEDVALUE ( 'Slicer'[Session] ) = "Dynamic w/o DE",
        IF ( MAX ( 'Table'[IsDyn] ) = 1, 1 ),
        IF ( MAX ( 'Table'[Session] ) = SELECTEDVALUE ( 'Slicer'[Session] ), 1 )
    )
)

4. Put the measure into the visual-level filters, set up show items when the value is 1.

Output:

Best Regards,
Yulia Xu

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

[jteague]

Thanks for your reply but I am still missing something. So I will add some more visuals and see if I can be more descriptive. I changed 'DE' to just be '0' if I dont want the data in the slicer and 1 if I do. Here is a snippet of my dataset:

What I want is this:

I'd rather the box not have 'DE' and '1' in it but the graph is performing correctly like this. But as soon as I turn it into a slicer it no longer works:

the settings are the same but it's not filtering it once I turn it into a Slicer.

Thanks for all your help.