Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Translating complex Excel chart into Power BI (Gantt planned vs actual implemented as stacked bar)

I have a gantt chart exactly the way I want it in Excel. I am trying to migrate the report to Power BI. I have tried several custom visuals from the Marketplace (including MSFT, xViz). I have tried i...
Need Help
  • v-sdhruv's avatar
    v-sdhruv
    1 year ago

    Hi Anonymous ,

    Yes this approcah might not be suitable if you are using large datasets.
    You can check-out this custom visual, Powergantt chart which might help you.
    Power Gantt Chart
    Also check-
    Gantt
    Timeline

    Hope this helps!

v-sdhruv's avatar
v-sdhruv
Community Support
1 year ago

Hi Anonymous ,

You can definitely replicate this in Power BI by following these steps-

1. Use Gantt Chart -> Got o custom visuals and choose MAQ Software Gantt Chart.

2.To provide an End date-> Create a calculated column->Table->New column
Use this- 

End date = 'Table'[Initial offset Waiting on Dependencies Start Date]+'Table'[Data values Work Days Call]

3.Take the new visual->add->Sr and Axis labels Phase Label as category

4.Legend->PvA

5.Start date- Initial offset and End date- End date

6.Data labels Series labels Dur as Data lables
You will get the following result-


Attached file for reference.
Hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You!