sync Slicers among pages

[hemingt]

Hi Teams,

I met a problem about sync Slicers among pages.

I have several tables in the dataset, named 'project_info', 'backlog info', and 'bug info', ..

project_info table has two columns named 'Project' and 'Release Version'

'backlog info' and 'bug info' also have these two columns 'Project' and 'Release Version'

I created two reports pages to show backlog info and bug info.

I want to create sync Slicers 'Project' and 'Release Version', and I find that only one Slicer can work well since only one relationship can be activated between two tables.

Do you have any ideas? Thank you!

[v-frfei-msft · Accepted solution]

Hi @hemingt ,

We can create a measure as below to make the visuals filtered by the measure, then we can get the excepted result as you wish.

Measure = IF(MAX('Bug Info'[Project]) in VALUES('Project Info'[Project]),1,0)

[hemingt]

here is an example data.

https://1drv.ms/x/s!AsM9bO8zGUN6qnhvPqVn6GafYeAS