Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |