Requirement to create a line graph with Milestones on the Graph based on the Project

[mikebi]

Hello, 

I am working with Project Data.  We have about 1,000 Projects. 

The users would like a line graph where on the X-Axis we display the Milestones.  The Milestones are different for each project. 

Is there an example on how to do this?  This is an example with test data. 

Thank You,

Michael

[v-tsaipranay]

Hi @mikebi ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @mikebi ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-tsaipranay]

Hi @mikebi ,

Thank you for reaching out to the Microsoft fabric community forum.

Could you please confirm if the issue has been resolved. I wanted to check if you had the opportunity to review the information provided by @rohit1991  .Please feel free to contact us if you have any further questions.

Thank you.

[rohit1991 · Accepted solution]

Hi @mikebi 

Could you please create the axis label and sorting:

In Data view, select the Milestones table and add this calculated column:

Axis = FORMAT('Milestones'[MilestoneSeq], "00") & " – " & 'Milestones'[MilestoneName]

Still in Data view: select the Axis column >> Column tools >> Sort by column >> choose MilestoneSeq.

(This keeps milestone names in the right order per project.)

Build the visual

• Insert a Line chart.
• X-axis >> drop Axis (the text we built).
• Y-axis >> drop Amount (or your metric).
• Add a ProjectName slicer to pick one project at a time (recommended for clarity).
• If you must compare several projects, put ProjectName in Small multiples works well up to a dozen projects.
• Add MilestoneDate and Amount to the Tooltips well so hovering shows exact date and value.