Separate overlapping tasks

[FinBrit]

Hi all,

First post here. Thanks in advance for any help.

To monitor a project I plan to link Power BI to an Outlook calendar - this is the easy part 😉 

I want to visualize project progress at different levels depending on the audience (high level milestones for leaders, detailed workpages for doers), always starting from the same Outlook calendar data for consistency and efficiency.

I've played with the standard Gantt chart custom visual and found it works well for standard gantt view and it is possible to have multiple tasks on the same line via Groups.

The problem is that if tasks overlap I need to display them on separate lines in the chart to make it usable.

One thought is to identify overlaps via Power Query/Dax and append the group name with a row number in the gantt visual but not sure where to start with the code.

Any other suggestions are welcome. Thanks!