Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Gantt automatically count %completion?

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 verifi...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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,
Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Its loading from a SQL server.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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