Visual Suggestion to Show Project Completion Status by Milestones

[prabhatnath]

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

[v-yohua-msft]

Hi, @prabhatnath 

Maybe you can create a measure to show completion status:

CompletionStatus = IF(NOT(ISBLANK(MAX('ProjectMilestones'[MilestoneName]))), TRUE())

Then put it in Matrix view:

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.

[prabhatnath]

Thank you @v-yohua-msft 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

[v-yohua-msft · Accepted solution]

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.

[dk_dk]

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]

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