Gantt chart for machine status with dynamic color

[amaaiia]

I need to create a Gantt chat por differente machine status, showing the status info of each machine in the same row, one after another. This is possible to reach (https://community.fabric.microsoft.com/t5/Developer/Gantt-chart-V-2-2-3-show-all-status-in-one-row-d.... Is it possible to set the color of the "tasks" by code? In Format Visual>Visual>Legend, you can manually select the color. But I have one task_color field with the hexadecimal color I need to set. Could it be possible?

If not, is there any other free Gantt chart or similar so I can reach this behaviour?

[v-echaithra]

Hi @amaaiia ,

We just wanted to follow up to ensure that your issue has been fully resolved. If there are any outstanding questions or if you need further assistance with anything, please don’t hesitate to reach out. We’re always here and happy to help in any way we can.

Your satisfaction is important to us, and we want to make sure you have everything you need.

Warm regards,
Chaithra E.

[v-echaithra]

Hi @amaaiia ,

Just checking in to confirm that your issue has been resolved. If you have any remaining questions or need additional assistance, feel free to reach out, we're always here to help.

Best Regards,
Chaithra E.

[v-echaithra]

Hi @amaaiia ,

Thank you @rohit1991  for your valuable inputs.

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Chaithra E.

[rohit1991 · Accepted solution]

In the standard Power BI Gantt chart visual (including the Microsoft Gantt and the “Gantt 2.2.3” custom visual), it’s not possible to set task colors dynamically using a field (like your task_color hex field). Colors can only be set manually in the visual formatting options, not by data.

Alternatives:

1. Deneb or Charticulator:
   Both are free custom visuals that support dynamic color assignment using fields. You can design a Gantt-like chart and bind bar colors to your hex color field. This requires a bit of setup, but it gives you full control.

2. Custom Visuals from Marketplace:
   Some other Gantt or timeline visuals might allow more flexible color formatting, but most free ones have similar limitations as the standard Gantt. Paid visuals (like xViz Gantt) do support this feature, but you’d need a license.

Out of the box, the default Gantt visual doesn’t support color-by-field. Use Deneb or Charticulator for full flexibility with dynamic colors, or look into third-party visuals if you need a ready-made solution.