Forum Discussion
Charticulator custom Gantt Chart
Hello, I would like to create the following Gantt Chart using the Charticulator tool:https://charticulator.com/app/index.html I have the following sample data: Project Start Date End...
Hi lbendlin , Thanks for noticing, that was a design misunderstanding. I fixed the image.
Still doesn't match. Your Project 1 shows three milestones in the picture but only one in the sample data.
You will need separate data points for Project Start/Project End and Milestones. For example:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCijKz0pNLlEwVNJRMjTQMzDWMzIwMgJyjEz0DCxhHENjPQMTGMclPy8VSAWlFueXFiWnArXG6iAMMoIaZIhkEJCPZJApjOOXX6KAbpgRimHGIC3mSFpAhhkiG2YG4/gkluBxlQlIryGqqyAcY6hB5sS7yhSk3xTJbiMLNFdZ4AoroEGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Project = _t, #"Start Date" = _t, #"End Date" = _t, #"Milestone Date" = _t, #"Milestone Status" = _t, Resource = _t]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Project", "Resource", "Milestone Status"}, "Attribute", "Value")
in
#"Unpivoted Other Columns"How to use this code: Create a new Blank Query. Click on "Advanced Editor". Replace the code in the window with the code provided here. Click "Done".
Hi lbendlin ,
I run your query to generate data, the result is this:
ProjectMilestone StatusResourceAttributeValue
Project 1 Done Resource 1 Start Date 10.03.2022 Project 1 Done Resource 1 End Date 24.09.2022 Project 1 Done Resource 1 Milestone Date 13.04.2022 Project 2 Not Done Resource 2 Start Date 10.01.2022 Project 2 Not Done Resource 2 End Date 24.10.2022 Project 2 Not Done Resource 2 Milestone Date 13.05.2022 Project 3 Late Resource 1 Start Date 17.05.2022 Project 3 Late Resource 1 End Date 24.11.2022 Project 3 Late Resource 1 Milestone Date 13.06.2022 Project 4 Not Done Resource 2 Start Date 21.01.2022 Project 4 Not Done Resource 2 End Date 24.01.2023 Project 4 Not Done Resource 2 Milestone Date 13.07.2022 Project 5 Done Resource 2 Start Date 25.06.2022 Project 5 Done Resource 2 End Date 28.11.2022 Project 5 Done Resource 2 Milestone Date 13.08.2022 Still my question remains: is it possible to create that type of Gantt chart using the Charticulator tool?