Forum Discussion
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 you in advance for any help!!
- Anonymous2 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.
2 Replies
- miTutorials
Super User
This feature is not available currently in Power BI !
- AnonymousNot applicable
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.