Creating connection between 3 survey score tables from different teams, but the same questions/date?

[Anonymous]

I'm very new to Power BI and I'm analyzing survey data.

There are 3 groups: Group A, Group B, and Group C. 

There are 15 different questions.

These questions were asked to the same group in Jan, Feb, and March.

I have a Group A table, Group B table, and Group C table. 

I think I'm having trouble modelling the data correctly (probably overcomplicating it). 

I try to plot a line graph with small multiples of the "question", "month" as the axis, and "score" as the values, it just doesn't turn out right and I also want to label them by the "groups" and cannot do so.

Any assistance on where my mistakes are? 

[Anonymous]

Hi @Anonymous,

I'd like to suggest you create a new calculated table to union these table records with a custom field to remark the source table.

New table =
UNION (
    ADDCOLUMNS ( GroupA, "Source", "GroupA" ),
    ADDCOLUMNS ( GroupB, "Source", "GroupB" ),
    ADDCOLUMNS ( GroupC, "Source", "GroupC" )
)

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , Either add a group name column in three table in power query and Append

Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Or create common dimensions like month and questions