Forum Discussion
syncing slicer only one way
- 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.
This feature is not available currently in Power BI !