Forum Discussion

Andi_R's avatar
Andi_R
Frequent Visitor
2 years ago
Solved

syncing slicer only one way

Hi everyone! Currently I have two slicers that I'm trying to sync, slicer_1 on page_1 and slicer_2 on page_2. Is it possible to have slicer_1 impact slicer_2, but slicer_2 not impact slicer_1? Thank ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Andi_R 

     

    Just as miTutorials  post that power bi doesn't support this feature now.

    But there are an alternative workaround:

    Here I create a set of sample:

    Then create a calculated table:

    Table 2 = VALUES('Table'[ID])

    In page 1, add a slicer and configure the sync slicer:

    And in page 2, use the ID which in table 2 to create a Sync slicer:

     

    Search for the Preselected Slicer in the Get more visuals:

    Enter a table(2):

    And create a measure:

    MEASURE =
    VAR _selected =
        VALUES ( 'Table 2'[ID] )
    RETURN
        IF ( SELECTEDVALUE ( 'Table'[ID] ) IN _selected, TRUE (), FALSE () )
    

    Add a Preselected Slicer:

    Finally, click the   of the Slicer in the page 2.

     

    The result is as follow:
    Page 1:

    Page 2:

    Then change the Preselected Slicer in page 2:

    Page 1:

    Best Regards

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