Forum Discussion
Solved
Filter table based on another table's values
I have a table on PowerBI, called records. I have a second table called questions in a many-to-1 relationship with records; AKA each record has many questions. Question have a "question", "answer", ...
anewsom
You should have a table visual includes all the column you want to show. Once the relationship between the tables is managed correctly, you could filter the 2 columns using the filter panel or create 2 slicers using Question and Answer column.Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Let your data model do the work. Make sure the filter direction is set up in a way that your question can be answered. You need a bidirectional filter as you want to filter from the many side to the one side.