Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@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.
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.
@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.
Regards,
Fahad Qadir
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |