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, 

  • 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.

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support

    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.