Displaying filtered data (CSV files with ID rows)

[Anonymous]

Hey, so I have to create a PowerBI Dashboard with data from CSV files for a school assignment, but I can't seem to figure out how to properly filter and connect the data... I struggled for days now, and since I'm totally new to PowerBI I just can't seem to figure it out. 

I have data from a survey that I want to evaluate. There were for surveys for different user groups (survey_id). I have different questions depensing on the survey_id, for example question_id=1 from survey_id=1 is different than question_id=1 from survey_id=2 and so on. Same goes for the answers and the answer_id's and the descriptions. 

I hope the image helps paint a picture. 

How am I supposed to correctly connect the data so that I get correct data out of it? like for example how people from survey_id=4 answered question_id=3 (there are 8 different options and I need it to show how the users answered). 

Help would be massively appreciated!

I'm sorry for the confusing thread and thank you for the help in advance!

[Anonymous]

Cool school assignment!

The answer before me is spot on, what you're struggling with modelling.

Your tables (let's think of them as excel sheets) for a second are connected. The glue that seems to connect them is "question_id" and "survey_id". What you're supposed to do is create a relationship between the relevant tables on "question_id" and "survey_id".

This can easily be done on the left hand side of your screen through the 'relationships' tab.

Essentially what this will do is the following, if you select a record in answers with survey_id = 1 related tables with a survey_id will bring up the same data. This is the first step towards being great at Power BI.

Why don't you try it out and let us know how it's going? If this already solved your problem, don't forget to mark as solved.

[Anonymous]

Yes, I tried to connect the tables, but the thing is, that the only meaningful connections were already made by PowerBI. I tried connecting the data myself, but it only let me do it m:n (which I guess is technically correct) and even then I cant seem to get the descriptions of the answers from the survey to show as text, because I can't seem to figure it out.. 😕 

The data: 
Survey(2017_survey.csv):

Survey Questions are like this(2017_survey_question.csv): 

And the answer descriptions(2017_survey_answer.csv):

then I have the anonymized user answers(in 2017_survey_user_answer.csv) where I have the survey_id, question_id, anonymized_user_id(irrelevant for the data I want to show), and answer_id (the answer the user gave to the quesion_id=x; from the survey_id=x.

How would you go on connecting the data? I can't seem to get it to correctly show the answer descriptions... 😕 

[Anonymous]

So connect your Survey(2017_survey.csv) with 2017_survey_answer.csv on survey_id.

What this does is basically connect your questions to your survey. The model now 'knows' which questions belong to which survey.

The next thing you want to do is connect 2017_survey_answer.csv on question_id. Now the model 'knows' which answers belong to which questions.

If you want you can connect in 2017_survey_user_answer.csv on answer_id to 2017_survey_answer.csv. Now you know which user is connected to what answer.

[v-lili6-msft]

hi, @Anonymous 

Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

I think you need to create the relationship among these tables.

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Best Regards,

Lin