Conditional Formatting with a Gantt Chart

Status: Declined
by dansilver1005 Occasional Visitor on ‎02-21-2018 09:32 PM

I'd like to setup conditional formatting for a gantt chart, so each task is associated with a specific color. This would be based off the category that the task falls within. So as an example, any tasks associated with Phase 1 would be green, any tasks associated with Phase 2 would be orange, any tasks associated with Phase 3 would be red, so on and so forth. And as people enter in additional tasks to the phase they are involved in, those tasks would be color coded accordingly.

 

Can anyone help me with this? I figured out how to manually adjust each task, but I'd like to automate this process.

 

The visual I'm using is the gantt chart by MAQ Software, as I found this one to be the most user friendly.

 

Appreciate any assistance you can provide.

 

Cheers!

 

Dan

Status: Declined
Comments
by Community Support Team
on ‎02-22-2018 11:20 PM

Hi Dan,

 

The bars are colorful. Do you mean you want to set them automatically? I'm afraid you need to go to https://maqsoftware.com/expertise/powerbi for support of this new feature.

Conditional_Formatting_with_a_Gantt_Chart

 

Best Regards,

Dale

by Vicky_Song Established Member
on ‎02-22-2018 11:21 PM
Status changed to: Declined
 
by dansilver1005 Occasional Visitor
on ‎02-23-2018 07:12 AM

Thanks Dale!

by MAQSupport Member
‎03-09-2018 01:43 AM - edited ‎03-09-2018 01:43 AM

Hello @dansilver1005,

Thanks for reaching out to us. We have added your request to our backlog.  

 

We are planning to take up this enhancement in our next build. We will notify you on this thread when we have an update on this. 

 

Thanks!

by jciromil Frequent Visitor
on ‎06-08-2018 12:24 AM

Hi Guys,

 

Is there any update on the said requirement? Is there a way to include a categorize background color for the Gantt Chart by MAQ Software? I need to give 3 colors based on my Project Type instead of giving "n" number of colors for all the project types included.

by Svyatoslav Visitor
on ‎08-03-2018 06:55 AM

Hi, @MAQSupport

Is it possible to setup automatically color for specific items? I can see in latest release new field "color". What does it do?

by MAQSupport Member
‎08-09-2018 08:06 PM - edited ‎08-09-2018 08:08 PM

Hello @Svyatoslav,

 

The “Color” data field is a feature that is in progress. We recommend you configure the legend colors using the ‘Bar formatting’ option available in the format pane, as shown below –

 

Gantt.jpg 

 

We will notify you when we have the “Color” data field functioning completely.

by Svyatoslav Visitor
on ‎08-10-2018 07:55 AM

Thank you @MAQSupport. I cannot use in color bars legent field values unless I put it also in categories. Is it possible to avoid this or am i doint something wrong?

by MAQSupport Member
on ‎09-07-2018 12:20 AM

Hello @Svyatoslav,

 

As of now Gantt Chart by MAQ Software requires that the data field that is being used for legend, must be displayed as well. 

We have added your request to our backlog and will let you know when we add this feature as an enhancement in the upcoming versions of the visual.

 

Thanks

 

by OskariNi Regular Visitor
on ‎10-15-2018 04:00 AM
Hi @MAQSupport, What is the current status with conditional formatting of bars in the Gantt chart? Also a great feature would a meter that could show the progress (percentage of completion) of each task (bar). Thanks, Oskari
Idea Statuses