Forum Discussion
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, both men and women. Actually, the user had a hard coded excel dashboard anf they want it in Power BI. Is there any way to do this? Any help can be appreaciated. I know this is a weird requirement. There will be no data across rows in t1,t2,t3,t4
So i mean to say in excel, they have color coded them very easily. But how can we do this in Power BI ?
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.
7 Replies
- Deku
Super User
You 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
- Deku
You 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
v-sgandrathiCommunity Support
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.
- v-sgandrathi
Hi Rajesh_Yarlagad,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
- v-sgandrathi
Hi Rajesh_Yarlagad,
As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.
Your understanding and patience will be appreciated.
