Forum Discussion

IHam's avatar
IHam
Helper III
7 years ago
Solved

Multiple Slicer syncing issues

  I have a report made up of multiple pages. On the first page are three slicers – Year, House and Name. I have used the Name slicer to sync to all of the other pages without any issues. However, I...
Need Help
  • ssugar's avatar
    ssugar
    7 years ago

    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)

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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

IHam's avatar
IHam
Helper III
7 years ago

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. 

 

  • ssugar's avatar
    ssugar
    Resolver III
    7 years ago

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

    • IHam's avatar
      IHam
      Helper III
      7 years ago

      Thanks for the help, I have sent a PM with a link to the de-personalised pbix file. hope this helps!

      many thanks

       

      • ssugar's avatar
        ssugar
        Resolver III
        7 years ago

        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)