Forum Discussion

hoegsdal's avatar
hoegsdal
New Member
9 years ago

Filter table based on selection in chart

I'm new to Power BI so this question might have been asked already but I don't know what to search to find the answer.   I have build a website with a survey. Each survey has a Yes / No question an...
Need Help
mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
9 years ago

It sounds like (from a modeling perspective) you need 2 tables - one with the QuestionId = 1 rows (yes/no), the other with the QuestionId = 2 rows (comments).  I would build this by editing the queries - I would create 2 Queries by "Reference" to your existing Query, with filters on each as per the previous sentence.

 

Then I would try to create a relationship between the 2 new tables.  The column chosen needs to be a unique key in at least one of the 2 tables.

 

With all that in place, you should be able to combine columns from the 2 new tables, with the relationship managing the cross-filtering.