Forum Discussion

Giada90's avatar
Giada90
Helper IV
1 year ago
Solved

particular chart

Hi, I need to do something like this:   and I have something like this for database:   activity duration in days phase 1 10 phase 2 20 phase 3 30 phase 4 40   how ...
  • v-menakakota's avatar
    1 year ago

    Hi Giada90 ,
    Thank you for reaching out to us on the Microsoft Fabric Community Forum.


    Yes, you can get this by Gantt chart by MAQ software as suggested by pankajnamekar25 ,thank you pankajnamekar for providing possible solutio.
    Here is the detailed process how to achieve it:

    Take a sample dataset which has the following column names Activity (Phase Name),Start Date, Duration (in days),End Date (optional). From get more visuals search for Gantt chart by MAQ software and add it. Select the Gantt chart and add the fields in the Gantt chart by Task name,Start date,End date and duration. If your dataset only has Start date and Duration,you can calculate End Date using this DAX:

    End Date = 'Table'[Start Date] + 'Table'[Duration (Days)]

    Here is the screen shot for better understanding:



    If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.