Forum Discussion
Solved
Visual Resource Load on Gantt Chart
Hello, I'm newer to Power BI, and trying to build some reporting for my team. Members are allocated to different projects, and I'm trying to build a visualization that shows how heavily utilized...
Hi bmg262 ,Thank you for reaching out in Microsoft Community Forum.Thank you SaiTejaTalasila for the helpful response.Please follow below steps to Show Utilization by Color in Gantt Chart;1.Create a new column to classify allocation as:100%, Partial (1–99%), or 0%.2.Combine allocation and status into a new column (e.g., "Confirmed - Partial").3.Use this new column in the Gantt chart’s color/legend field to visually differentiate bars.4.Customize data colors in the Gantt settings (e.g., dark for 100%, light for partial, blank for 0%).Please continue using Microsoft Community Forum.If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.Regards,Pavan.
Hi bmg262 ,
Thank you for reaching out in Microsoft Community Forum.
Thank you SaiTejaTalasila for the helpful response.
Please follow below steps to Show Utilization by Color in Gantt Chart;
1.Create a new column to classify allocation as:
100%, Partial (1–99%), or 0%.
2.Combine allocation and status into a new column (e.g., "Confirmed - Partial").
3.Use this new column in the Gantt chart’s color/legend field to visually differentiate bars.
4.Customize data colors in the Gantt settings (e.g., dark for 100%, light for partial, blank for 0%).
Please continue using Microsoft Community Forum.
If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.
Regards,
Pavan.