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