Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
1 year ago
Solved

Visual Suggestion to Show Project Completion Status by Milestones

I need a suggestion in Power BI Visual for below scenario:
 
I have a ProjectMilestones Table. Above table has columns like: ProjectNames, MilestoneName, TaskCompleteDate. 
 
ProjectName is the Name of the Project os string type, MilestoneName is the Milestone that project has completed of string type. TaskCompleteDate is the date when the MileStone is completed for the Project. 
 
One Project can have multiple rows, each with one milestone name that is completed on the date. 
 
We have a fixed set of Milestones (MS1, MS2, MS3, MS4, MS5, MS6, MS7, MS8....) that any project can have.
One project might have completed only a few of the milestones from all available milestones.
 
Milestones are sequential, meaning projects complete the milestones in sequence. 
That mean one project might have 2 milestones (MS1, MS2) while another can have 5 milestones in the same sequence (MS1, MS2, MS3, MS4, MS5), but can't have non sequential milestones like (MS3, MS6, MS6, MS8, MS9).
 
What will be the best visual that can be used in Power BI to show milestones completed by each project? The visual does not need to show the Datecompleted. Just a visual that shows the progress for the project showing how much milestones are completed.  
 
Thanks,
Prabhat
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, prabhatnath 

    All you need to do is create a bar chart and put the fields in it to see the number of each species

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

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

5 Replies

  • dk_dk's avatar
    dk_dk
    Super User
    1 year ago

    Hi prabhatnath ,

    If you can modify the query or add a calculated column to your data, you could add a "MilestoneNumeric" column that is a Whole Number format, and equal to the numerical value of the Milestone (MS1=1,MS2=2, etc..)
    Then you can create a new measure: MaxMilestone = MAX(Data[MilestoneNumeric])


    Finally, a bar chart where the Y axis is your ProjectName, and the X axis is your MaxMilestone measure.


    • prabhatnath's avatar
      prabhatnath
      Advocate III
      1 year ago

      Thanks dk_dk for your input.
      In Y-Axis it will show the project name, but in x-Axis I want to show all Milestone Names instead of the new numeric column. Can you suggest?

      Thanks,
      Prabhat

    • prabhatnath's avatar
      prabhatnath
      Advocate III
      1 year ago

      Thank you Anonymous for your input. I can see the milestone for each project as per your sample. But I will like to show the output as a graph, may be a Bar Chart or something?

      Thanks,

      Prabhat

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi, prabhatnath 

        All you need to do is create a bar chart and put the fields in it to see the number of each species

         

        How to Get Your Question Answered Quickly

        Best Regards

        Yongkang Hua

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