@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 !!
