Forum Discussion

Matt22365's avatar
Matt22365
Icon for Resolver III rankResolver III
5 years ago

Portfolio Gantt Chart

Hi All

I am hoping for some advice

I am trying to create a portfolio report with data which comes from project online. I have tried to use some of the Gantt chart options but cannot get the view I need.

What I would like is a line per project which has the key tasks broken down and some KPIs built in

I have included a picture of the view I would like

Has anyone done something similar and can help me set it up?

Thanks in advance

Matt 

Need Help

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Matt22365 

    Could me provide me a sample data model like yours that may make it easier for me to understand your requirement?

     

    Best Regards,

    Rico Zhou

     

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

    • Matt22365's avatar
      Matt22365
      Icon for Resolver III rankResolver III
      5 years ago

      Hi Anonymous 

       

      The data is coming from Microsoft project online so im not sure how I can send sample data. Essentially you get a list of tasks with an identifier for the predeccesor, the duration of the task, the start and end date of the tasks

       

      Thanks

       

      Matt 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Matt22365 

        I build a sample to have a test.

        Due to you only have Start and End you need to calculate the Duration by End - Start.

        Result:

        The gantt chart will show task name in column and won't show values with the same task name in one row.

        And we can't add icons or image in gantt chart directly.

        I build a table/matrix visual and use conditonal format to show icon.

        You may refer to blogs below.

        Blog1: Use conditional formatting in tables

        Blog2: Dynamically Display Images in Power BI

        Your demand is a good idea, while it is not supported to implement in Power BI currently.
        You can vote up this idea for this function：Gantt chart conditional formatting
        Or you can submit a new idea to improve the Power BI.
        It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

         

        Best Regards,

        Rico Zhou

         

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