Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
draner
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
PavelR
Solution Specialist
Solution Specialist

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

 

 

 

 

View solution in original post

6 REPLIES 6
PavelR
Solution Specialist
Solution Specialist

@draner

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

 

Regards.

Pavel

draner
Frequent Visitor

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
Solution Specialist
Solution Specialist

Could you show sample of data?

draner
Frequent Visitor

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
Solution Specialist
Solution Specialist

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

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

 

Thank you very much for your help and your time!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.