Forum Discussion
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", and recordID columns.
I want to make a fitler which filters the records based on the question and answer columns.
So if I have a question of "Color" (among many other questions) i can say "give me records with a question called 'Color' with an answer called 'Red'"
Is there a way to do this with a filter or will I need to make a new column each time?
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.
2 Replies
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.
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.
