Forum Discussion
One Slicer for Multiple Data Points on Same Page
I'm trying to understand if you can have mutliple slicers on one page and when you update the dates on one of those slicers it changes the dates automatically on the other slicer.
The slicers are attached to unrelated tables and I can't relate the dates in those tables to a Calendar table becaues those two tables are already related to a third table to find the User name of the person who completed the task. To help explain I have an audit table that shows when audits where completed and I have recognition table that shows the dates of when people received recognition or gave recognition. Those two tables don't have names just numbers, the third table that they both are linked to takes those numbers and gives me a name. I want to be able to filter on a particular person and then select a timeframe, without having to change the dates on multiple slicers, as I'd like to add more tables to this visual in the future.
4 Replies
Hi noyesae ,
Based on your description, do you want to use a date slicer from an unrelated table to affect other date slicers in the same page?
If so,you can try to create a measure and apply it to the visual level filter of each slicer.
Try measure like this:
Measure = IF(MAX('Table'[date])in VALUES('Table 2'[date]),1,0)Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I tried the formula but unforunately after creation I can't make it a Date format so it's not allowing me to put the Measure into the Slicer.
Hi noyesae ,
Apply this to the slicer's visual level filter.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
