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 N...
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.

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