Connect 2 slicers with the same values

[TheLearner1]

I have 2 tables that are connected via relationship. Each of the 2 tables has a column called Segment that contains the same distinct values. In PBI report, I have one visual using data from one table and another visual using data from the other table. I also have 2 slicers on the Segment column from each table. My question is -- how can I have one slicer that filters both tables (since the options are the same between both)?

[Ritaf1983]

Hi @TheLearner1 
You need to create third table "Segment" with uniwue values from both of your 2 tables and modify relationship one to many from both of your 2 tables to this third.

Link to the sample file 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[TheLearner1]

Thanks @Ritaf1983 - both of the tables have a one to many relationship with Date table so when I create a relationship between them for Segment, it turns off the Date relationship. I can't turn on both relationships, but I need both connections. 

[Ritaf1983 · Accepted solution]

@TheLearner1 
That seems that you need to modify your model.
Try to :

union those tables (2 with segment and value) or to manupulate relationships with dax inside measures using userelationship function
https://www.youtube.com/watch?v=2NW2XKblrME

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly