Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody,
i don't know how explain my problem without picture, so :
I wan't to create the excel chart :
All datas are from MS Project.
I think I need to create a new table, but how I can create a dynamic table with columns names is project name with planned work for each Employee ?
Have you any idea ?
Best regard,
Draner
Solved! Go to Solution.
So if you have data with those three columns, just use Stacked column chart visual and put Employee Name to Axis, Project Name to Legend and Planned Work to Value.
If you have data like the pic, then do some transformation as described below. (I use my sample data)
Highlight "project" columns (to chose more fields use CTRL key) and hit "Unpivot columns" on Transfrom Card.
Rename new field as Project.
Use the columns in Stacked column chart visual as described in the beginning of my post.
Also it is better to create measure for Planned work, then just use the source column.
Regards.
Pavel
Hi PavelR,
I know where is datas, but I don't know how use/store it to create same depicted visual.
P.S: Sorry for my bad English.
Could you show sample of data?
Yes, in MS Project I have Table "Affectations".
With columns :
"Nom Projet" => Project Name
"Nom Ressource" => Employee Name
"Affectation Travail" => planed Work
With Excel, I use datas like this :
I think I need to create dynamical table, but I don't know if it correct, and I don't know how ...
So if you have data with those three columns, just use Stacked column chart visual and put Employee Name to Axis, Project Name to Legend and Planned Work to Value.
If you have data like the pic, then do some transformation as described below. (I use my sample data)
Highlight "project" columns (to chose more fields use CTRL key) and hit "Unpivot columns" on Transfrom Card.
Rename new field as Project.
Use the columns in Stacked column chart visual as described in the beginning of my post.
Also it is better to create measure for Planned work, then just use the source column.
Regards.
Pavel
I am fu***ng ba***rd, practice makes perfect.
Thank you very much for your help and your time!
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |