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.
Hi Team
I urgently need help to create a matrix table in the form of gantt which shows Project Plan vs actual with respect to Complted In Progress Defered Not started. Any suggestions are appreciated to bring plan vs actual in a gantt format.
Sample data
Project | Team Member | Planned Start | Planned Finish | Actual Start | Actual Finish | Status |
A | Roy | 12-May-22 | 19-May-22 | 12-May-22 | 14-May-22 | Completed |
B | Pam | 20-May-22 | 31-May-22 | 21-May-22 | In Progress | |
C | Tim | 23-May-22 | 1-Jun-22 | Deferred | ||
D | Ken | 25-May-22 | 15-06-2022 | Not Started |
Output needed as:
Solved! Go to Solution.
Hi @Anonymous
These blogs and videos have provided some ideas and solutions. See if they can be applied to your scenario.
Creating A Gantt Chart In Power BI Using Matrix
Create A Gantt Chart In Power BI With A Matrix Visual
GANTT-LIKE CHART IN POWERBI USING CONDITIONAL FORMATTING IN THE MATRIX VISUAL
Matrix chart to Gantt chart in Power BI
From the expected output, you have Week as the smallest level. How do you want to specify the start date and end date of every week? Some weeks may cover two calendar months.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
These blogs and videos have provided some ideas and solutions. See if they can be applied to your scenario.
Creating A Gantt Chart In Power BI Using Matrix
Create A Gantt Chart In Power BI With A Matrix Visual
GANTT-LIKE CHART IN POWERBI USING CONDITIONAL FORMATTING IN THE MATRIX VISUAL
Matrix chart to Gantt chart in Power BI
From the expected output, you have Week as the smallest level. How do you want to specify the start date and end date of every week? Some weeks may cover two calendar months.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
it doesnt work with custom visual, as most of my columns are measures, thats why am looking for matrix table to convert in a bar style timeline.
Hi
There are a few custom visuals that display gantt visualizations.
Click on the three dots under visualizations and chose "Get more visuals" and search for Gantt
I've tried the first one, and it seems that it could help you, you just need to transform your data accordingly
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
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 |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |