Forum Discussion
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.- Anonymous5 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
Community 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.
- AnonymousNot applicable
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
Community 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
Community 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.- AnonymousNot applicable
Thanks for this, as replied above, I find the interaction option and enabled it, then it's working now.