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

[v-jejensen1]

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 internet searches. (That's how I found tips to help me do it in Excel.) I have not been able to figure out how to replicate this in Power BI.

Does anyone here have a solution?

Desired result:

Description: Planned vs actual timeline with a spacer between deployment phases. The start date is a series for the original offset with the bar set to transparent. The bar length represents calendar days duration, the data label represents work days duration. I have custom labels for series. The displayed axis labels are abbreviated for easy viewing. If you hover over the data point, you get the full data label with all the info. I manually set the colors for planned vs actual and manually created a legend for reporting purposes. Effectively, it's a conditional format based on the planned vs actual (PvA) value.

Annotated data set:

I have the ability to transform the data set any way needed to get the output I want.

I have the Excel file, but file type .xlsx is not supported.

[v-sdhruv]

Hi @v-jejensen1 ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If you still need any assistance let us know
Thank You

[v-sdhruv]

Hi @v-jejensen1 ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @v-jejensen1 ,

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]

Hi @v-jejensen1 ,

You can check out these links which might help you to  build the Gantt Chart.
https://community.fabric.microsoft.com/t5/Desktop/Matrix-to-Gantt-Chart-Visualization/td-p/3016678
https://www.youtube.com/watch?v=8pbFvBMT9L8.

Additionally, you might want to check these charts-
Gantt
Timeline

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!

[v-jejensen1]

I had tried this approach. I figured out how to get my blank "spacer" rows and the conditional formatting worked well, but I bumped up against the 100 column limit.

[v-jejensen1]

@pankajnamekar25 
Can you expand a bit on the DAX and CF? I had been trying something along those lines and hadn't gotten it to work.

[v-sdhruv]

Hi @v-jejensen1 ,

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!

[pankajnamekar25]

Hello @v-jejensen1 

Use Gantt chart from appsource visual that will help.

Other way you can use Mtrix to achieve this with DAX and CF.

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[v-jejensen1]

@v-sdhruv, this is definitely closer than I've gotten before. I'm still missing the spacer between phases. (I'm a little cautious about choosing a paid solution.)