Forum Discussion
gantt chart - not from custom visuals
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.
Solution SageHi 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.
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.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