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
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

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

 

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'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.