How reproduce an excel chart into PBI ?

[draner]

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

[PavelR]

@draner

what is exactly your problem? To gain data, or create depicted visual?

Regards.

Pavel

[draner]

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.

[PavelR]

Could you show sample of data?

[draner]

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

[PavelR · Accepted 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

[draner]

I am fu***ng ba***rd, practice makes perfect.

Thank you very much for your help and your time!