Forum Discussion
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 visul
| ID | Grant Manager | Grant_Start | Grant_End |
| 20001 | Mary | 04/01/2022 | 03/31/2026 |
Expected table visul
| ID | 20001 |
| Grant Manager | Mary |
| Grant_Start | 04/01/2022 |
| Grant_End | 03/31/2026 |
Thanks,
Hank
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 !!
2 Replies
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 !!
Hey Fahad,
I appreciate your reply and insights. I am sorry to mislead you in my original post. My workflow (listed below) allowed the user to select a project by dropdown list, and then the final table visualization would demonstate the information associated from a wide and long table by the matching the id. It means the example in the first post was not the original table but the resulting table visualization.
Your insights on how to transpose the columns to rows based on my configuration would be appreciated.
