Forum Discussion
Trying to create one table with multiple columns
I am new to Power Bi. I have survey results, where the questions are 1A, 1B, and I would like to create a table where the rows are Response "1", "2", "3" and the Columns are 1A, 1B. There shou...
Anonymous
you can try this
in PQ, select the first column and unpivot other columns
then you can use matrix visual to get the expected output
ryan_mayu
Super User
Super UserYou can create a dim table which is 1, 2, 3 and connect this table to 1A and 1B.
what dose your sample data look like? could you pls provide some sample data?