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...
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?