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.
I have a source data Excel that looks like this. Call it ProjectData.xlsx
Project | Start | Finish |
A | 9/1/2021 | 9/5/2021 |
B | 8/25/2021 | 9/20/2021 |
C | 9/10/2021 | 9/20/2021 |
D | 8/5/2021 | 8/31/2021 |
E | 9/25/2021 | 10/31/2021 |
F | 9/5/2021 | 11/21/2021 |
It's a project start and end date table, which I get from a different department in our company. We get this every week, and using this, we calculate an Excel gantt chart of sorts, based on several conditions. Finished Excel looks like this:
Notes:
For example, the formula for D2 would look like this:
=IF(AND(D$1 >= $B2, D$1 <= $C2), IF($C2 - $B2 <=10, "Short", "Long"), "-")
Now, only using the ProjectData.xlsx which I get from the aforementioned other department, I would like to recreate this in PowerBI. I know that to simply show project durations, I could use a Gantt chart controls, but I don't think I can accomplish something like this that has multiple conditions.
So, what's the best way to go about creating this (presumably using a Matrix visual?) in PowerBI?
Solved! Go to Solution.
The approach used here is very similar to the one suggested by @amitchandak. But it is more specific to your post. You can make a matrix visual with your data, a Date table that goes from Today to Today() + 365, no relationship between the two tables, and these two measures - one for the value and one for the conditional formatting.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
The approach used here is very similar to the one suggested by @amitchandak. But it is more specific to your post. You can make a matrix visual with your data, a Date table that goes from Today to Today() + 365, no relationship between the two tables, and these two measures - one for the value and one for the conditional formatting.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This worked perfectly, thanks!
@Anonymous , refer if my attempt of putting in matrix can help
Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs
Thank you for the response, but this doesnt seem like what I'm looking for.
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |