Forum Discussion
Solved
Table Visualization - from columns to rows
Hey everyone, I would need your help on how to transpose the data from columns to rows by using Table visualization. Could I know if you could provide your insights on this task Current table...
Result
chyang0107 I duplicated the table just for this example, you don't need to duplicate it. You first need to select all column and unpivot. For filter the table by ID i create a new column in PQ and use fill down. Power BI file attached.
Power Query Transformation
Regards,
Fahad Qadir
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Result
chyang0107 I duplicated the table just for this example, you don't need to duplicate it. You first need to select all column and unpivot. For filter the table by ID i create a new column in PQ and use fill down. Power BI file attached.
Power Query Transformation
Regards,
Fahad Qadir
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!