Forum Discussion
Rajesh_Yarlagad
Helper I
Helper Icondtional formatting
Hi is there any way this can be done in Power BI . I wont be having any data under men, women and other. I just want it to be color coded. For task 1, lets say only Men to be color coded. For task 2...
Hi Rajesh_Yarlagad,
Standard Gantt visuals in Power BI focus mainly on task timelines (start date, end date).
They do not support breakdown within a single task across categories (like Men, Women, Other) naturally.
Therefore, to achieve your Excel-style color-coded behavior:
- Manually create a dataset with Task, Date, and Category columns.
- Use the Deneb visual, not Gantt. Deneb lets you fully control the bar segmentation by both date and category.
- Tasks will be Y-axis, Dates will be X-axis, and Color will represent Men/Women/Other.
Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.
Thank you.
Deku
Super User
Super UserYou can use a custom visual, there are a few Gannt one. Or you can build one with Deneb using the following Vega lite example, just need to add a legend spec to get the colour
Rajesh_YarlagadBut Gaant chart does not provide to get break down by category. It provides a breakdown by date primarily