cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dandutch Frequent Visitor
Frequent Visitor

Creating a timeline visual with milestones

Dear all,

 

I've been working with Power BI for about six months now, so I feel quite familiar with the basics. However, currently I am facing a challenge I can't figure out myself. I would like to display a timeline with certain dates as milestones. The distance between these milestones should be dependent on the duration between the corresponding dates.

I would like to use this visual for delivery performance tracking in projects. My Idea is that I would filter for a certain project number an then the visual should display something similiar to this:

 

Project Timeline 2.PNGExample Timeline with Milestones

 

My (simplfied) data :

                                

Project NameDate A (Project Start)Date BDate CDate D (Project End)
Project X01.01.201701.02.201701.06.201701.01.2018
Project Y01.10.201601.01.201701.05.201701.08.2017

 

I have found solutions wich are similiar to my task, but not completley fulfill it. At least, as far as I understood them

Pulse Chart Solution

Bar Chart Solution

 

I would be very glad if someone could point me to such custom visual or explain how existing ones could be used for this manner.

 

I am looking forward to your suggestions.

Many thanks in advance and best regards,

Dan

7 REPLIES 7
Community Support Team
Community Support Team

Re: Creating a timeline visual with milestones

@dandutch,

 

You may take a look at https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381377?src=office&tab=Overview.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dandutch Frequent Visitor
Frequent Visitor

Re: Creating a timeline visual with milestones

Hi chuncz,

 

considering the data attached in my first post, do you have any idea how I could use multiple start and end dates for this visual? What I would need is a visualtization from A to B, from B to C and then from C to D in one line or in terms of this visual: for one identy. Like it is with "John Holiday" or "Vladimir Holiday".

timeline visual original.pngOriginal Visual Example

However, my visual seems to ignore the second dates (Start Date "Date B" and End Date "Date C"). Most probably it doesn't work this way, but I couldn't find a proper discription for multiple dates.

 

Timeline Visual.PNGDate B to Date C is not displayed

 

dandutch Frequent Visitor
Frequent Visitor

Re: Creating a timeline visual with milestones

Hi @v-chuncz-msft

 

I had a second look at this visual and unfortunately it does not meet my requirements.

For one, it does not allow to enter multiple Start/End Dates without rearanging my complete data set.

As explained, my data is structured like this table:

 

Project NameDate A (Project Start)Date BDate CDate D (Project End)
Project X01.01.201701.02.201701.06.201701.01.2018
Project Y01.10.201601.01.201701.05.2017

01.08.2017

 

In order to work with the suggested visual, the data should be structered similiar to this (Example for Project X):

 

Project NameCategoryStart DateEnd Date
Project XA to B01.01.201701.02.2017
Project XB to C01.02.201701.06.2017
Project XC to D01.06.201701.01.2018

 

I do not consider this to be practicable.

 

Second, the formating possibilities are rather insuficcient (e.g. displaying Duration or Milestones).

 

Do you have any other ideas?

 

BR,

Dan

arguane Occasional Visitor
Occasional Visitor

Re: Creating a timeline visual with milestones

Dandutch - I am trying to create the same. did you have any luck with this timeline?

mpbpbi Frequent Visitor
Frequent Visitor

Re: Creating a timeline visual with milestones

 

 

You could do something like using using clustered bar charts with color saturation to change the bar color based off of time between points since I do not believe there is a way to make something with dynamic bar length. Not exactly what you are looking for but a possible temporary solution to this. The averages at the bottom are for a second metric i was tracking that occured between each step.

 

 

pbi line.png

oliver1981 Occasional Visitor
Occasional Visitor

Re: Creating a timeline visual with milestones

I'm also trying to do something similar - has anyone found a solution? Thanks.  

bmoorearch New Member
New Member

Re: Creating a timeline visual with milestones

Ditto to the above ask for a way to present timline of single entity/element with multiple milestones.  Timeline Storyteller is a great visualization, but limited to start-date and end-date.  Need a way to layer in sub-dates/events along that singular timeline.