cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbouichi Member
Member

Gantt automatically count %completion?

2017-11-13_16-45-49.jpgFile 12017-11-13_16-45-31.jpgFile 22017-11-13_16-44-49.jpgGantt Visual

Hallo everybody,

 

Is it possible to let the gantt visual completion count only the orders that are labelt with verification. 

Maybe a other solution to automaticaly count the verification.

 

I simplified the tabels just to work out a concept

Duration = Verification + uitvoeren

Verification = %completion duration

 

it must be 2 different data tabels

1 ACCEPTED SOLUTION

Accepted Solutions
cbouichi Member
Member

Re: Gantt automatically count %completion?

Hallo Lydia,

 

First of all i want too thank you for your helping hand.

The problem is of the relationship between the 2 tables wasn't working right.

I made a new table and used the command Append Queries. Now i was able to make te right relationship between the 2 tables.

 

Regards,

Charaf

 

 

View solution in original post

10 REPLIES 10
Moderator v-yuezhe-msft
Moderator

Re: Gantt automatically count %completion?

@cbouichi,

Drag Status field to visual level filters of Gantt chart, and set its value to verificate, then check if you get expected result.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cbouichi Member
Member

Re: Gantt automatically count %completion?

thx for your reply,

 

It workt for the example but not for the real deal. I cant understand why. Sorry for my newbie questions.2017-11-15_9-00-13 werkorders.jpg2017-11-15_9-00-13 werkorders.jpg2017-11-15_8-58-06 planning concept.jpg

Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Gantt automatically count %completion?

@cbouichi,

You would need to drag Druu.1 field to Duration of Gantt chart, please review the following screenshots.
1.JPG2.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cbouichi Member
Member

Re: Gantt automatically count %completion?

This is the result. I feel im close.2017-11-15_9-33-57 this is the result.jpgThis is the result but its not accurate

Moderator v-yuezhe-msft
Moderator

Re: Gantt automatically count %completion?

@cbouichi,

Why do you drag Staus field to %Completion of Gantt chart? In the third screenshot of your original post, you drag Completion field of Werkorders table to %Completion of Gantt chart.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cbouichi Member
Member

Re: Gantt automatically count %completion?

1. Completion= the status field that are marked with verification.

2. The screenshot in the original qeustion was a simplified data table too see if it works.

3 the last screenshot are the orginal data table were i have to implement it in. (its more advanced)

 

2017-11-15_13-31-40 reply.jpg

 

 

 

 

Moderator v-yuezhe-msft
Moderator

Re: Gantt automatically count %completion?

@cbouichi,

Could you please export data of the your original tables to Excel and share me the Excel file to test? You can upload Excel file to OneDrive and post shared link of the file here.

Also please post expected result based on your original tables in table format.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cbouichi Member
Member

Re: Gantt automatically count %completion?

Can i export the data table werkorder too excel from BI?

Its loading from a SQL server.

Moderator v-yuezhe-msft
Moderator

Re: Gantt automatically count %completion?

@cbouichi

You can create a table visual using all the fields of you table in Power BI Desktop, then click "..." in the right corner  of the table visual,  you can export data to CSV by selecting "Export Data".

Please share me sample data of your two tables(Planning and werkorder). 

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)