cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Solution Supplier
Solution Supplier

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

 

 

 

 

View solution in original post

6 REPLIES 6
Highlighted
Solution Supplier
Solution Supplier

Re: How reproduce an excel chart into PBI ?

@draner

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

 

Regards.

Pavel

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

Highlighted
Solution Supplier
Solution Supplier

Re: How reproduce an excel chart into PBI ?

Could you show sample of data?

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

Highlighted
Solution Supplier
Solution Supplier

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

 

 

 

 

View solution in original post

Highlighted
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!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors