Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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)
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)
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |