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)
I'm not able to replicate your issue.
Here's the pbix file I made to test:
https://github.com/ssugar/PowerBICommunity/raw/master/community-sol-563464.pbix
Could you send along the data you're using to test?
Also, send along a screenshot showing the sync slicers area while you have one of the slicers selected.
Many thanks for doing this - on reflection, its something to do with the ranking code that i have written which isn't being passed the slicer information from the first page (although there were some very strange things happening with the slicers!).
Its difficult to pass the pbix file through as there are data protection issues but I will try and send some screen shots and the ranking coade when i can this weekend.
Many thanks again
Here are three pictures - the first of the front page and the second two of the page wheich isn't syncing
The first is what is passed through and then second has the slciers made visible and then selected again.
The code for the ranking is:
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)
Hi IHam,
By my tests, I cannot reproduce your issue in my site eirther. More details should be better.
I would appreciate it if you could share your dummy pbix file which can reproduce the scenario, so that we can help further investigate on it?
If your pbix file with sensitive data, you could share with private message.
Best Regards,
Cherry
Thanks Cherry, unfortunatly i just can't share the pbix file or create a dummy as there is too much sensitive data, I was wondering if it was a linkage issue. The two main tables are linked by a unique student number (the centre table has one entry per student and is linked to a many entry for the student points value) and the slicers are for Name, House and Year.
