question

TheLaziest-6095 avatar image
0 Votes"
TheLaziest-6095 asked IgorGelin-0063 answered

SSRS: customize area bar chart (gantt chart) — different colors based on expression

I have a dataset like this, but there are more rows

122400-table.png

There I have employees` names and their qualifications in my project, start date and end date of their vacations and vacations` id.

Then i did an area bar chart (gantt chart) based on this dataset. Lines are grouped by vacation_id, start of line is vacation start date and end of line is vacation end date. The vertical axis shows the names of the workers, and the horizontal axis shows the dates of current month.
All lines are blue now. But I need to switch the lines color to red if vacations overlap by dates for those employees who have the same qualifications in my project.
Is it possible to do this?

sql-server-reporting-services
table.png (4.7 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Could you share what your current area bar chart (gantt chart) looks like?

0 Votes 0 ·

122684-chart.png
Like this

0 Votes 0 ·
chart.png (10.0 KiB)

Do you mean that when employees have the same position, the overlapping parts of vacations are displayed in red, and the non-overlapping parts are displayed in blue? That is, does the bar graph of a certain employee have two colors at the same time?
If I misunderstand what you mean, please feel free to correct me.

0 Votes 0 ·

1 Answer

IgorGelin-0063 avatar image
0 Votes"
IgorGelin-0063 answered

You may use SQL to resolve you problem. Add a boolean column "OverlappedQualifications" in your dataset. Then control the color based on the value in the column.

HTH,

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.