Forum Discussion
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
Anonymous,
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
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)
Anonymous,
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,
LydiaCan i export the data table werkorder too excel from BI?
Its loading from a SQL server.
Anonymous，
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