New Gantt parsing error

[mstoc]

The new Gantt looks great! However I am getting the error "Expression parse error: +utcFormat(timeOffset('day', timeOffset('month', toDate(utcFormat(datum['startDate'], '%m')+'/01/'+utcFormat(datum['startDate'], '%Y')), 1),-1), '%d')". Do you know what might be causing this?

[Giammaria]

Hey @mstoc, A separate user had a similar issue. Can you confirm that your root node has an id, and that your second level nodes have that id set as their parentId?

[mstoc]

I can't drop a pbix in this reply, is there another way I could share it? I also suspect part of the issue of the gantt not showing up is also because of the field specification mapping is not making connections for some columns.

[Giammaria]

You don't have this option available, or will it not allow you to attach a .pbix?

[mstoc]

Cannot attach pbix unfortunately

[Giammaria]

Can you email it to [email protected]?

[Giammaria]

Hi @mstoc. I didn't have a ton of time, but noticed that some of the fields weren't mapping correctly because the first letter of each of their names was capitalized.

Additionally, I need to fix the dependencyId field so that it knows how to deal with empty strings. In the meantime, set that field to either null in power query or BLANK() in DAX if you don't have a need for dependency lines.

There is some other weirdness going on with expand/collapse. I wonder if that has something to do with the parent/child ids. I need to dive in further, but have had limited bandwidth today.