GANTT Chart and DAX Expressions

[hanmcm]

Hi I am trying to create a gantt chart which will show all the scheduling for projects which are in development. I need to be able to have multiple date fields within the start and end date fields and be able to filter using a slicer. Is this possible? Also need dates that have gone past their due date to become 'overdue' in status column is there a DAX Expression to make this possible?

Thanks

[Anonymous]

HI @hanmcm,

>> I need to be able to have multiple date fields within the start and end date fields and be able to filter using a slicer.

Please provide more detailed information and data structure to help us clarify your requirement.

>>Also need dates that have gone past their due date to become 'overdue' in status column is there a DAX Expression to make this possible?

You can add a calculated column with dax formula to check date and return tag.

Regards,

Xiaoxin Sheng