Hi folks
I just wondering that is possible to change colors assosiated with Epic statutes in gantt reports.
For example right know it looks like issue with status ToDo appears on chart as blue color. The problem is that in my project Epics doesnt have such status.
Instead I have statutes like Evaulating, Funnel and other… how can I correlate statutes with colors on report? it`s even possible?
In Gantt chart, the bars represent three pieces of information: the beginning and end dates of a task as bar length and the task progress as bar color. Task progress is based on completion in percentage, not the status. The color meaning is hardcoded like this:
blue - upcoming tasks, milestones, and completed tasks without completion ratio;
green - completed tasks with completion ratio (%);
However, you may define a calculated measure to represent the task progress in percentage based on the status. For the calculation, use condition CAE WHEN … THEN. For example:
CASE
WHEN [Measures].[Issue status] MATCHES "Done|Closed" THEN 1
WHEN [Measures].[Issue status]="In Progress" THEN 0.5
WHEN [Measures].[Issue status]="Evaulating" THEN 0.25
WHEN [Measures].[Issue status] MATCHES "Backlog|Open" THEN 0
END