Create Gantt Chart

(0) Share

Report

Posted on by s44

691

Hello, I am trying to create a diagram similar to the picture below.

But I can't, when I try I don't have the colored bars displayed.

I have something like that :

All properties that I have :

Indicator Label :

Fill : If(ThisItem.Status.Value="Not Started";White;If(ThisItem.Status.Value="Active";Orange;If(ThisItem.Status.Value="Delayed";Red;If(ThisItem.Status.Value="Completed";Green;Gray))))

X : Value(StartDays.Text) * 'Gantt Tasks_1'.Width/365

EndDays Label :

Text : DateDiff(Date(Year(Now());1;1); DateValue(EndDate.Text))+1

EndDate Label :

StartDays Label :

DateDiff(Date(Year(Now());1;1); DateValue(StartDate.Text))+1

StartDate Label :

Can you help me please ? Thanks in advance 😞 !

Categories:

Using Apps Using Formulas

Dataflows

All responses (10)

Answers (1)

iAm_ManCat 18,206 Most Valuable Professional on at

Like (1)

Report
Re: Create Gantt Chart

Excellent, glad I could help!

One minor fix:

lblIndicator.X

change to:

Value( DateDiff( Date( Year(Now()), 1, 1 ), ThisItem.StartDate ) + 0 )* (galBodyMonths.Width / 365)

and

lblIndicator.Width:

(Value( DateDiff( Date( Year(Now()), 1, 1 ), ThisItem.EndDate ) + 1 ) - Value( DateDiff( Date( Year(Now()), 1, 1 ), (ThisItem.StartDate + 0) ) )) * (galBodyMonths.Width / 365)

This should fix them starting too far from left and the gaps between items 🙂
s44 691 on at

Like (1)

Report

Re: Create Gantt Chart

It's work thank you ! C:
s44 691 on at

Like (1)

Report

Re: Create Gantt Chart

It's work !
iAm_ManCat 18,206 Most Valuable Professional on at

Like (0)

Report

Re: Create Gantt Chart

If you select the error notification it will take you to the formula that is erroring - this will likely be the name of the list, the names of the startdate and enddate columns, the status, and the description(title).

You will need to change these to match the naming and column types of your datasource
s44 691 on at

Like (0)

Report

Re: Create Gantt Chart

I recovered the file but I can't adapt it with my SharePoint data :c @iAm_ManCat
Verified answer

iAm_ManCat 18,206 Most Valuable Professional on at

Like (1)

Report

Re: Create Gantt Chart

Yeah, that's not a great tutorial to be honest, their naming convention is poor and they have way too many unnecessary items.

I will put together a blog on this sometime soon, but there's the test .msapp I created as a proof of concept - you can use File> Open to browse for this .msapp file and then open it - those few labels and galleries are what you need for a basic gantt - feel free to copy them out of that app into your own.

Any issues copying it to your App then please let me know,

Ciao,

Gant Test.msapp
s44 691 on at

Like (0)

Report

Re: Create Gantt Chart

As you can see in my post, this is exactly the tutorial I followed but it doesn't work as you can see 😕 @iAm_ManCat
iAm_ManCat 18,206 Most Valuable Professional on at

Like (0)

Report

Re: Create Gantt Chart

oh, well he included the actual .msapp so that you could copy out the contents and modify it for your own needs rather than a full tutorial

You can look at this tutorial for a step-by-step:

GanttChart Using Microsoft PowerApps (c-sharpcorner.com)
s44 691 on at

Like (0)

Report

Re: Create Gantt Chart

I saw it but I didn't understand. His tutorial is way too complex for me 😕
iAm_ManCat 18,206 Most Valuable Professional on at

Like (0)

Report

Re: Create Gantt Chart

Hi,

To save you some time - Someone has already gone through the trouble of doing this so you don't have to - you can get it from the community samples here and then tweak it for your needs:

Gantt-like Display Using Standard Power Apps Contr... - Power Platform Community (microsoft.com)

Cheers,