Forum Discussion
rebam12
1 year agoHelper I
data transformation
I have this type of question .. now i dont know how i map the data and create the graph.. Source Values 1-6 1 Not familiar 2 Do not trust at all 3 Slightly trust ...
audreygerred
1 year agoSuper User
Hi! You would def want to unpivot in Power Query so that your data looks like below:
Then, in Power BI desktop you would join this table to the value field in the unpivot
And, you would join this table to the attribute field
- rebam121 year agoHelper I
audreygerred u mean i have to create 2 tables for join ?
- audreygerred1 year agoSuper User
These are the three tables you would have:
1.
2.
3.