Forum Discussion
Multiple Slicer syncing issues
Hi IHam,
Your problem is that the House and Year slicers on the name page aren't actually synced with the House and Year slicers on the points page.
When you're on the name page, click on the View tab, then click on the "Sync slicers" checkbox. This will open a pane to the left of the standard visualizations pane.
Then click on the House slicer on the name page, and you'll see that it has a blank checkbox for the Name page (same for the Year slicer)
Check the box beside Name, and then it should work (do the same for the Year slicer as well)
My guess is that the problem is actually related to your ranking code.
Here are the DAX expressions you sent over:
Rank in Year = rankx(all(vw_eBillbook[BillbookName],vw_eBillbook[txtHouseCode]),vw_PowerBIRandC[Points Total],,DESC,Skip)
Rank in House = rankx(all(vw_eBillbook[BillbookName]),vw_PowerBIRandC[Points Total],,DESC,Skip)
The ALL() function returns all rows ignoring applied filters: https://docs.microsoft.com/en-us/dax/all-function-dax, so I'd guess that's where the issue lies. You may want to look at using allexcept() or allselected().
Thanks for the help, I have sent a PM with a link to the de-personalised pbix file. hope this helps!
many thanks
Hi IHam,
Your problem is that the House and Year slicers on the name page aren't actually synced with the House and Year slicers on the points page.
When you're on the name page, click on the View tab, then click on the "Sync slicers" checkbox. This will open a pane to the left of the standard visualizations pane.
Then click on the House slicer on the name page, and you'll see that it has a blank checkbox for the Name page (same for the Year slicer)
Check the box beside Name, and then it should work (do the same for the Year slicer as well)