gantt chart - not from custom visuals

[bartek_wachocki]

Is there a way to create gantt chart manually (not using custom visuals)?

I need it to be saved as pdf. 

Here is how it's work in excel:

https://www.youtube.com/watch?v=_u_jm1211D4

I need similar workaround.

[bartek_wachocki]

I need to show gantt charts saved to pdf format. Gantt charts from custom visuals (and every other custom visuals) could not be exported to pdf. Is there an option to do a Gantt chart manually?

Like here in excel:

https://www.youtube.com/watch?v=_u_jm1211D4

I am looking for a similar workaround.

[v-xjiin-msft]

Hi @bartek_wachocki,

Based on the video, the way to create a Gantt chart in Excel is to format the Data Series' color in stacked bar chart. For this method, you can also achieve it in Power BI desktop. Please refer to following sample:

Original stacked bar chart:

For formatting: go to Format pane -> Data colors and you'll see the colors of all the data series -> change the color to white:

Then as I know, currently it is impossible to export Power BI report to pdf format and Power BI REST API has no export operation. But we can print an entire dashboard, a dashboard tile, a report page, or a report visual to PDF from Power BI service.

Reference: https://community.powerbi.com/t5/Desktop/How-to-export-Dashboard-as-PDF-file/td-p/159298 

https://community.powerbi.com/t5/Desktop/Export-power-bi-charts-graphs-into-excel/td-p/105173 

Thanks,
Xi Jin.

[bartek_wachocki]

Hi Xi,

Thanks for support. Maybe I was not precise.

The idea is to publish the Gantt chart to Power Bi Services and then export to pdf. Sorry I did not mention about it.

As I know custom visuals cannot be exported to pdf, right?

So that why I try another way to build this chart

The example you shared is partially right. Gantt charts used to have dates in axis x.

I could not reproduce the chart using dates. 

Consider this data set:

Task	Start date	Days to compleate
task1	23.03.2018	13
task2	25.03.2018	5
task3	30.03.2018	23
task4	06.04.2018	45
task5	07.04.2018	12
task6	08.04.2018	7
task7	09.04.2018	6
task8	10.04.2018	45
task9	11.04.2018	33

B

[v-xjiin-msft]

Hi @bartek_wachocki,

=> The idea is to publish the Gantt chart to Power Bi Services and then export to pdf. As I know custom visuals cannot be exported to pdf.

I know you want to export report on Power BI Service. And no, not only custom visual cannot be exported to pdf. Also as I said above currently it is impossible to export Power BI report to pdf format and Power BI REST API has no export operation. But we can print an entire dashboard, a dashboard tile, a report page, or a report visual to PDF from Power BI service.

=> I could not reproduce the chart using dates. 

You should know that Power BI desktop is different from Excel. Also the Stacked Column Chart in Power BI is different from the one in Excel. So with more complicated dataset, we cannot format stacked column chart to create gantt chart. If you want to create gantt chart, please try custom Gantt visual. 

Thanks,
Xi Jin.

[bartek_wachocki]

Thanks v-xjiin-msft

I have found quite recent post about publishing custom visuals.

https://docs.microsoft.com/en-us/power-bi/service-publish-to-powerpoint

I see a light in a tunnel, cos most recenty export as microsoft call it "Certified custom visuals" is available:

"Certified custom visuals are supported. A certified custom visual has been approved for use with Power BI, meets certain code requirements, and has passed strict security tests. You can learn more about certified custom visuals."

It is about export to Power Point but having Power Point presentation it is easy to save it as pdf.

I have not tested it yet but it seems promising