One Slicer for Multiple Data Points on Same Page

[noyesae]

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.

[V-lianl-msft]

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.

[noyesae]

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.

[V-lianl-msft]

Hi @noyesae ,

Apply this to the slicer's visual level filter.

Sample .pbix

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

[noyesae]

@V-lianl-msft Thank you for continuing to look into this for me.  I'm pretty sure that I did everything you did but it's still not working for me.  When I put the measure into the filter area for the Date and the Visual all the data disappears.  Not sure why that is happening.  

Also I noticed in what you sent me when you change the date in the Date slicer the Export dates change but the Import dates do not, did you intend for that to be the case.  I would need something that could change both slicers.