Forum Discussion

anewsom's avatar
anewsom
Regular Visitor
6 years ago
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", ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.