Forum Discussion

colettb's avatar
colettb
Helper I
1 year ago
Solved

Help with How to Create a Timeline

Hi Community!   I am trying to make a graphic like below.  I have multiple studies with three main milestone dates (denoted by colored circles). I need to have a bar that shows the total time the p...
General Comment
Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    Hello colettb 

     

    i would do something like this.

    1. create list of date from Start Date up to End Date

    2. create calendar table

    3. create relationship between two table

    4. create a measure define value (this makes the width of column is not too long or else the value will be date format)

    Value =
    IF(
        not ISBLANK(SELECTEDVALUE('Table'[Custom.1])),
        1,
        0
    )

    5. create two measure for conditonal formating (make background color red and make value transparant)

    Color Background =
    IF(
        [Value]=1,
        "#FF0000"
    )
    Color Font =
    IF(
        not ISBLANK([Value]),
        "#FFFFFF00"
    )

    5. assign conditional formatting for background and font

    6. create a calculated column to check whether the list of date coincide with any of milestone date

    7. assign conditional formating icon

     

    Detail is in pbix.

     

    Hope this will help.

    Thank you.

Irwan's avatar
Irwan
Super User
1 year ago

hello colettb 

 

in my case, i created a multiple date in power query because in power bi you need a value in those days to be filled.

 

from this value

becomes this value

using this m-code

Table.AddColumn("Previous Step", "Custom", each Table.AddColumn(#"Filled Down", "Custom", each {Number.From([Start])..Number.From([End])}))

 

then you can plot in matrix visual to get that values in between two dates.

 

Hope this will help.

Thank you.