Forum Discussion
Connect 2 slicers with the same values
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)?
Anonymous
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=2NW2XKblrMEIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi Anonymous
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 quicklyThanks 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
Anonymous
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=2NW2XKblrMEIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly