Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multi Date Slicers are not syncing

Hello,

 

I am creating 2 date slicers in one page as following:

 

The left-hand one "Date" is using Dax to get the date range from another table.

the right-hand one is coming from date hierarchy, source from same "Date" table but different column, where the year, quarter, month, weekNum get.

 

Now the problem is, if I change the "Date" slicer, i can see the options in right-hand slicer are auto synced: see the 2021 Year is not displayed

 

But if from the beginning, I start to use slicer on right-hand, the left-hand "Date" range is still remaining, will not sync with the chosen options: see the "Date" slicer is still displaying from 1/1/2020 although only 2021 options are chosen on right-hand slicer.

 

Seeking your help to this.

Thanks in advance.

H

  • Hi Anonymous ,

     

    Please check whether the "sync slicer" option is enabled in both visual, and whether there is a bidirectional filtering relationship between the dates of the two tables.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi AllisonKennedy , thanks for correcting me, I've changed to "Date" type. Then I found it is because the interactions are disabled by default...after changing the setting, they are syncing now.

     

7 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion

    Anonymous  I'm not sure on this specific problem, but many issues with dates stem from not having it marked as a date table. I would also recommend creating your date table in Power Query if possible, rather than DAX, but that's just my preference as I find it better for performance. 

    https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

    Once you mark as a date table, you'll lose that hierarchy on the 'date' column and will only have the hierarchies you create yourself, and though I haven't tested I think that might fix your problem here.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi AllisonKennedy 

       

       

      The date table has been marked to "Date" as a "calendar icon" is shown.

      I also created the Hierarchy manually.

       

      Have no idea why this is happened.

      Thanks for your reply.

      H

       

      • AllisonKennedy's avatar
        AllisonKennedy
        Icon for Community Champion rankCommunity Champion

        Anonymous The fact that the calendar icon is shown indicates to me that it is not marked as a 'Date table'. Please click the three dots next to the table, then 'Mark as date table' and select the 'Date' column. This will change the icon and remove the date hierarcy. 

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Please check whether the "sync slicer" option is enabled in both visual, and whether there is a bidirectional filtering relationship between the dates of the two tables.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for this, as replied above, I find the interaction option and enabled it, then it's working now.