Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Help needed visualizing Gantt/Timeline Chart

Hello, I'm looking to visualize a timeline for a project. My input table structure looks like this:

 

Project IDFunding ApprovedScope CompleteProject Started
Project 12/1/20192/20/20194/15/2019
Project 22/2/20193/2/20194/10/2019
Project 32/3/20193/3/20195/5/2019
Project 42/4/20192/15/20194/1/2019
Project 52/1/20193/10/2019

4/20/2019

 

 

The output I want is something like this:

 

 

Still a newbie when it comes to powerbi. Any help is appreciated.

 

Thank you!

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    There are three date fields in your dataset, if you could try this way:

    In Edit Queries, Unpivot Funding Approved,Scope Complete,Project Started column

    Then download the custom visual Timeline Chart

    Best Regards,

    Lin

     

     

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    There are three date fields in your dataset, if you could try this way:

    In Edit Queries, Unpivot Funding Approved,Scope Complete,Project Started column

    Then download the custom visual Timeline Chart

    Best Regards,

    Lin

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Edit: Never mind, Found it!! "Y Axis Label Length" under appearance. Thank you once again!

       

      Thank you this worked! I just have to figure out how to make Project IDs show up fully on the Y axis. They cut off with like "Proj..." so its hard to tell if its Project 1, 2, 3 etc.