Forum Discussion

CCI_Dev's avatar
CCI_Dev
New Member
2 years ago
Solved

Timeline/Schedule Milestone Comparison

Hello community,  Power BI novice here, hoping to get some help creating a timeline style visual.  I am trying to create a visualization that illustrates date shift on major milestones from a construction schedule.  I've trid using the Microsoft Gantt chart visualization, Timeline Basic, & Craydec Timelines.  I also tried creating a scatter plot but couldn't quite get that to work either.  Ideally I'd like to be able to customize the markers or at least colors. 

 

Any tips, third party visualizations, or tutorial links would be helpful.  Thanks much!

 

This is a simplified version of what I'm looking for created in Excel using a scatter plot. 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi CCI_Dev 

    Based on your description, i create a visual use scatter plot in Power BI, you can refer it.

    Sample data 

    1.Create two calculated columns in table.

     

    Rank = RANKX('Table',[Date],,ASC)
    UpdateType = [Update]&" "&[Type]

     

    Then select the UpdateType column and select sort by rank column

    2.Create a measure 

     

    Measure = 1

     

    Then put the date to x-axis, put the measure to y-axis, and put the UpdateType column to legend.

    Then you can set the mark in properities.

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi CCI_Dev 

    If you want to achieve this, you can create the following field that the update field is blank, but the date field is not, you can refer to the following picture.

    Then modifty the measure to the following

    Measure = IF(MAX('Table'[Update])=BLANK(),-1,1)

    Then set the min and max value of the y-axis.

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi CCI_Dev 

    Based on your description, i create a visual use scatter plot in Power BI, you can refer it.

    Sample data 

    1.Create two calculated columns in table.

     

    Rank = RANKX('Table',[Date],,ASC)
    UpdateType = [Update]&" "&[Type]

     

    Then select the UpdateType column and select sort by rank column

    2.Create a measure 

     

    Measure = 1

     

    Then put the date to x-axis, put the measure to y-axis, and put the UpdateType column to legend.

    Then you can set the mark in properities.

    Output

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

  • CCI_Dev's avatar
    CCI_Dev
    New Member
    2 years ago

    Thank you Yolo! That is exactly what I'm looking for.  The only thing would be I need the dates to plot relatively, not evenly spaced out.  Is that an option?  

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi CCI_Dev 

      If you want to achieve this, you can create the following field that the update field is blank, but the date field is not, you can refer to the following picture.

      Then modifty the measure to the following

      Measure = IF(MAX('Table'[Update])=BLANK(),-1,1)

      Then set the min and max value of the y-axis.

      Output

      Best Regards!

      Yolo Zhu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.