Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I'm looking to visualize a timeline for a project. My input table structure looks like this:
Project ID | Funding Approved | Scope Complete | Project Started |
Project 1 | 2/1/2019 | 2/20/2019 | 4/15/2019 |
Project 2 | 2/2/2019 | 3/2/2019 | 4/10/2019 |
Project 3 | 2/3/2019 | 3/3/2019 | 5/5/2019 |
Project 4 | 2/4/2019 | 2/15/2019 | 4/1/2019 |
Project 5 | 2/1/2019 | 3/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!
Solved! Go to Solution.
hi, @RustyNails
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
hi, @RustyNails
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
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.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |