Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
104 | |
102 | |
88 | |
66 |