Timeline showing start date, end date and current date per project/initiative

[Rajbunny]

Hi All - I am relatively new to power BI so there may already be a solution to my problem. I am trying to create a visualisation that looks like this

from the below data source.  where the timeline above would be dependent on the initiative selected below.

TimelineStart	Timeline End	Initiatives
01-Aug-17	31-Aug-17	Intiative 1
02-Aug-17	01-Oct-17	Intiative 2
03-Aug-17	01-Nov-17	Intiative 3
04-Aug-17	02-Dec-17	Intiative 4
15-Aug-17	12-Jan-18	Intiative 5
06-Aug-17	02-Feb-18	Intiative 6
07-Aug-17	06-Sep-17	Intiative 7
28-Aug-17	27-Oct-17	Intiative 8
01-Sep-17	30-Nov-17	Intiative 9
10-Sep-17	08-Jan-18	Intiative 10
21-Aug-17	18-Jan-18	Intiative 11
22-Aug-17	18-Feb-18	Intiative 12
02-Oct-17	01-Nov-17	Intiative 13
04-Oct-17	03-Dec-17	Intiative 14
04-Oct-17	02-Jan-18	Intiative 15
05-Oct-17	02-Feb-18	Intiative 16
08-Oct-17	07-Mar-18	Intiative 17
14-Oct-17	12-Apr-18	Intiative 18
14-Oct-17	13-Nov-17	Intiative 19
14-Oct-17	13-Dec-17	Intiative 20
16-Oct-17	14-Jan-18	Intiative 21
14-Oct-17	11-Feb-18	Intiative 22

Ive already wasted several days trying to figure this one out - for some reason I am unable to understand these timeline visualisations and how the source data needs to look in order to create the visualisation.

Would much appreciate if someone could point out a visualisation i could use and advise how the source data should look in order to get the visualisation to work. 

[vanessafvg]

@Rajbunny maybe its better to discuss what your objective is?  are you wanting to slice by month?   which visual are you using because there are several that use time, is the the timeline storyteller?

[Rajbunny]

My objective is to achieve a visualisation that looks like this image (which is manually created in the most hateful powerpoint) 

It shows a timeline in months, positions a start and end indicatior on the time line as well as today's date. Another thing I have to do is change the colour of the arrow based on wether the project is on track or delayed (red, amber, green) 

Im trying to use a Gantt chart now - I WAS having issues with duration showing as 1 day regardless (managed to fix duration with a datediff converstion - this requirement is not made clear in the video guide). 

I am now struggling with the % complete (showing as 100% for all initiatives, regardless -so I assume once again the data needs to be converted from a percentage to a decimal value). Also, once I have  figured out how the data must look to for a visualisation to show anything at all,  I still have to learn how to customise the look and feel as well as determine how i can set start and end dates for both the timeline (jul 17-jul18)  start and end dates for the selected initiative (currently only shows the latter) - it will be devastating to learn in the end that it can not create the visualisation I am after.  First prise would be a recommendation to use a custom visualisation that someone knows will do the job along with advice on how the source data should look (to avoid more time waste).  Second prise is advice on how to set up the source data to get the Gantt custom visualisation to get as close to expected as possible

[vanessafvg]

@Rajbunny what about this one?

https://powerbi.microsoft.com/en-us/blog/what-story-does-your-timeline-tell-introducing-the-timeline...