topic Re: Charticulator custom Gantt Chart in Custom Visuals Development Discussion

Charticulator custom Gantt Chart

ileana2019 — Mon, 17 Jan 2022 12:31:34 GMT

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 Date	Milestone Date	Milestone Status	Resource
Project 1	10.03.2022	24.09.2022	13.04.2022	Done	Resource 1
Project 2	10.01.2022	24.10.2022	13.05.2022	Not Done	Resource 2
Project 3	17.05.2022	24.11.2022	13.06.2022	Late	Resource 1
Project 4	21.01.2022	24.01.2023	13.07.2022	Not Done	Resource 2
Project 5	25.06.2022	28.11.2022	13.08.2022	Done	Resource 2

Is that even possible?

Thank you!

Re: Charticulator custom Gantt Chart

lbendlin — Sun, 16 Jan 2022 21:36:55 GMT

Your sample data doesn't match the picture. The picture suggests that project 1 was put on hiatus and then restarted?

Re: Charticulator custom Gantt Chart

ileana2019 — Mon, 17 Jan 2022 12:32:49 GMT

Hi @lbendlin , Thanks for noticing, that was a design misunderstanding. I fixed the image.

Re: Charticulator custom Gantt Chart

lbendlin — Mon, 17 Jan 2022 22:17:15 GMT

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

Re: Charticulator custom Gantt Chart

ileana2019 — Tue, 18 Jan 2022 09:14:54 GMT

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?