Forum Discussion

jteague's avatar
jteague
Frequent Visitor
1 year ago

Slicer Value change for only one button

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
jteague
Frequent Visitor
1 year ago

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.