Forum Discussion
Help with How to Create a Timeline
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.
Hi Irwan!
I'm happy to give some sample data. I've added teh start and end date columns you suggested. I would need to have some sort of mark during the start-end period where the 3 milestones occurred.
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.