Reply
Highlighted
Frequent Visitor
Posts: 9
Registered: ‎12-13-2018
Accepted Solution

Issues with Table Relationships and Slicers

Hello PowerBI Experts, Here is a situation I am hoping to get some help with: 1. I have two tables (Tables A and B) that all contain three common fields/columns (let's call them Size, Shape, and Color for confidentiality purposes) 2. I have a page of a report containing various visuals, some of which display values that are calculated using data from both tables (e.g. Table A(Size) divided by Table B(Color), etc.). 3. The page also has slicers on it for the three fields/columns of interest (i.e. a "Size" slicer, a "Shape" slicer, and a "Color" slicer). To create these slicers, I used the corresponding fields from Table A. 4. The slicers only appeared to be affecting the portions of the visuals coming from Table A (which I suppose makes sense since I used the fields from Table A to create the slicers). 5. The next thing I did was to go to "Manage Relationships" and create a Many-to-Many, bi-directional relationship between Tables A and B based on the "Size" field. This appeared to solve two-thirds of my problem because now the slicers for "Size" and "Shape" both appear to correctly affect all parts of all visuals on the page. The issue now, however, is that the "Color" slicer still only affects the Table A portions of the visuals. 6. The next thing I could logically think to do was to create an additional Relationship between the two tables, based on "Color". The problem is, this won't work because it is telling me I then have to deactivate the other relationship, stating: "You can't create a direct active relationship between Table A and Table B because an active set of indirect relationships already exists between these tables. To make this relationship active, set the Cross filter direction to 'single', delete, or deactivate any of the indirect relationships first." Changing the cross filter direction doesn't allow me to activate the relationship either. Does anyone have any idea what the issue is here? I'm really stuck spinning my wheels for now. The only workaround I currently have is to just add two slicers for "Color" from both tables, directing the user to make sure to select the same color from both slicers to ensure the data is accurate. How can I set up the relationships such that all three slicers affect the data/visuals from both tables? Any help is much appreciated!

Accepted Solutions
Community Support Team
Posts: 4,002
Registered: ‎07-09-2016

Re: Issues with Table Relationships and Slicers

@rdcooper,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/One-slicer-for-two-tables-M-M/td-p/523095

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 4,002
Registered: ‎07-09-2016

Re: Issues with Table Relationships and Slicers

@rdcooper,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/One-slicer-for-two-tables-M-M/td-p/523095

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.