Click through stacked column chart not filtering table correctly

[Anonymous]

Hi, I am trying to figure out why clicking on a section of a stacked column chart is not fully filtering a table on the same page.  It shows it as part of the filter of the table, but it is only filtering on the column and not the data part that is sorting the stacked column.  For example, the stacked chart is sorted by rating and the columns are different categories.  When clicking on say a rating of 5 for category A in the stacked column, it should show only the items from category A with rating of 5, but ALL of the ratings are appearing in the table.  The filter shows that it SHOULD be filtering, but it does actually filter it.  I have a screenshot below where it shows the rating as being part of the filter, but it is not actually filtering on the rating AND the category.  It is ONLY filtering on the category and showing all the ratings in the table.  If we click on the rating in a slicer, it filters correctly, but not if you click in the stacked column chart.  Please let me know if you need more information, but I hope this is an easy fix or a bug and not working as intended.  Thank you!

[Anonymous · Accepted solution]

I finally figured it out.  I had only single direction for the relationship between two tables to the main table.  I needed to change it to bi-direction.  That made it work!