Forum Discussion
Table not filtering when selection made in another table
Hopefully this makes sense and someone can help me. So I have two tables in my model. The first (called parentDetails) is a list of parents names, their child's name, and what year group that child i...
I tried another route which might give better clarity about the problem. I created a Matrix, and from you can see below, a single value is repeated accross a row. When that option hasnt been selected by a parent for that year group, it correctly is left blank, but what I don't get is the unique values for each cell.
- amitchandak
Super User
Anonymous , how the tables are joined, In a single direction join filter will from 1 to many side.
If there two visual, slicer interaction can be off
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
I figured it out, I just needed to change the 'cross filter direction' option to 'both' in when editing the relationship between the two tables.
- I was also missing the same. Thanks Anonymous
