Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Aravindanbu3012
Frequent Visitor

PowerBI Advanced Gantt chart Definitive Logic color coding problem

Aravindanbu3012_0-1723556914492.pngAravindanbu3012_1-1723556923878.png

Definitive Logic's Custom Gantt Chart provides a timeline in either calendar years or government fiscal years with tasks able to be broken up into separate swim lanes. Formatting options include flagging tasks to be formatted differently, adding baselines beneath tasks, and a color measure to change task colors. BUT I am not able to change the colors of the taskname here using the option colors and there is no option called data colors as well in the formatting pane 
How do I color code this visual?

1 ACCEPTED SOLUTION
arava
Regular Visitor

I don't see any documentation after a quick web search, but I would assume they are looking for color hex values (ie "#XYZ123" format). Create a calculated column that uses the SWITCH( ) function to determine the proper color for each row in your table.

View solution in original post

1 REPLY 1
arava
Regular Visitor

I don't see any documentation after a quick web search, but I would assume they are looking for color hex values (ie "#XYZ123" format). Create a calculated column that uses the SWITCH( ) function to determine the proper color for each row in your table.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.