Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Toolbox Talk Dashboard

Hello,   Could anyone advise the best way of putting a Toolbox talk visual together please? I cant get my column engineers to group together. Their names are individual columns.   Thanks, 
Need Help
Tutorial Requests
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi Anonymous ,


    Based on your description, the engineer names exist in different columns.

    If you want to display all engineers in the column of the matrix, please use the unpivot function in the transform data.

    https://docs.microsoft.com/en-us/power-query/unpivot-column 


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi Anonymous ,


Based on your description, the engineer names exist in different columns.

If you want to display all engineers in the column of the matrix, please use the unpivot function in the transform data.

https://docs.microsoft.com/en-us/power-query/unpivot-column 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.