SSRS show trend chart over column chart per series groups

Question

Need help in designing following report in SSRS, where I have a chart report with 2 category grouping fields and 1 series group field (as with category grouping, the reason being, i need to show columns in group of 4 joined together based on their grouping on top) .

Below are my queries
1. how to show my category grouping values on top of chart (showing group in different color) and series grouping values on bottom of chart (under each bar)
2. I need to show trend line over each series group data.

For example, First category group is over hotel name, second category group is over room type (deluxe, executive & suite) and one Series group over week number (for a month report), and the chart value is total occupancy (per hotel per room type per week number). Now for point 1, Hotel name and room type needs to be on top of the column (total occupancy) chart, where a week iteration number (1,2,3,4 for a month) at the bottom of the chart under every column.
And for point 2, I need to show trend line per room per week occupancy was improved or not.

Regards, Sujay

Answer 1

Hi Sujay,

According to your description, you want to display the two category group values at the top of the total occupancy value. Also you want to create a trend line over series values.

For your first requirement, you can specify the Label data as a combination of two category group values and total occupancy values. Then change the location of series group value legend. Please refer to below screenshot.

For your second requirement, you can add additional total occupancy values to the Chart Data panel, then change the chart type as Smooth Line.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 2

Thank you for your response, regarding the trend chart issue, i believe i wasn't clear in my query. Adding a new series as line chart will span across the chart area, whereas what i need to show is small arrow (trend arrows either up arrow, down arrow or straight arrow) over each "series group" to show whether there was an increase/decrease or no change in the occupancy over the weeks for a single room type in a hotel. Hope that clears my question.  

Answer 3

Hi Sujay,

In Reporting Services, it's not supported to create a trend arrows for the occupancy over the weeks for a single room type in a hotel. We can create the trend line just I mentioned above.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support