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

Need Help

4 Replies

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