Forum Discussion
Rajesh_Yarlagad
Helper I
1 year agocondtional 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...
- 1 year ago
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
1 year agoYou can then category (T1, T2 etc) on y axis and dates on x. Then legend/colour code for men, women, men & women.
Don't understand your response