timelines

[powerbitv]

I have 4-5 relases on three porgarms all round the year. Eash release has a start date and end date.

Program A:

• Releases1: Start date: 1 Jan End Date 30 March
• Releases2: Start date: 1 April End Date 30 Sept
• Releases3: Start date: 1 Oct End Date 30 Dec

Program B:

• Releases1: Start date: xxx  End Date yyy
• Releases2: Start date: xxx  End Date yyy
• Releases3: Start date: xxx  End Date yyy

Program c:

• Releases1: Start date: xxx  End Date yyy
• Releases2: Start date: xxx  End Date yyy
• Releases3: Start date: xxx  End Date yyy
• Releases4: Start date: xxx  End Date yyy

I wish to visualize them in in three rows (time lines), one for each program. And show each release from start-end date in as a colored ribbon.

Please suggetd if there is any custom visualzation for this..

[McCow]

Hi @powerbitv

I'm not sure, that such custom visualisation exist (Gantt it's not that you really need).

But I believe, that your request can be realised with basic Stacker bar/column chart. Whats you need is some additional calculations with measures and/or calculated columns.
I will be recommended you to convert all your dates to values (for example to length of days) and normalize it to year (or max work duration).

Best regards

[powerbitv]

Thanks, let me try this and gt back.

[McCow · Accepted solution]

@powerbitv, another trick: create 5+1 measures, where 5 measures is for length of every possible release and the first one - for length between start of the year and begin of first release every Program. And the color for this extra bar is white (or another relevant background color).

So create you own individual "Gantt" diagram.

Best regs

[powerbitv]

Thanks this helps