syncing slicer only one way

[Andi_R]

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 you in advance for any help!!

[Anonymous · Accepted solution]

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.

[miTutorials]

This feature is not available currently in Power BI !