cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
draner Frequent Visitor
Frequent Visitor

How reproduce an excel chart into PBI ?

Hi everybody,

i don't know how explain my problem without picture, so :

I wan't to create the excel chart :

Excel Chart.PNG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
PavelR Established Member
Established Member

Re: How reproduce an excel chart into PBI ?

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.

1.PNG

 

Rename new field as Project.

 

2.PNG

 

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

 

 

 

 

6 REPLIES 6
PavelR Established Member
Established Member

Re: How reproduce an excel chart into PBI ?

@draner

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

 

Regards.

Pavel

draner Frequent Visitor
Frequent Visitor

Re: How reproduce an excel chart into PBI ?

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 Established Member
Established Member

Re: How reproduce an excel chart into PBI ?

Could you show sample of data?

draner Frequent Visitor
Frequent Visitor

Re: How reproduce an excel chart into PBI ?

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 :

Excel Datas.PNG

 

I think I need to create dynamical table, but I don't know if it correct, and I don't know how ...

PavelR Established Member
Established Member

Re: How reproduce an excel chart into PBI ?

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.

1.PNG

 

Rename new field as Project.

 

2.PNG

 

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 Frequent Visitor
Frequent Visitor

Re: How reproduce an excel chart into PBI ?

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

 

Thank you very much for your help and your time!