SSRS - How to create height dynamically for bar charts

  • Hello,

    I have earlier calculated the height for all my bar charts dynamically by specifying the Maximum value for the y axis in the Maximum properties.

    For example, =MAX(Parameters!AvgValue.Value) * 2.0

    This has been working for me and it will increase the height based on the maximum value displayed in the graph.

    On the Y-axis I am counting the days, let call it CountOfDays.

    Categories axis: Date for example YearMonth.

    Values consists of all AverageValues for each month/year.

    Now to the problem that has occured for me. I have changed some of these graphs to be a stacked bar chart. I have categories in each bar, for example

    status 1, status 2, status 3 and so on. I added a new attribute, called Status, to the dimension in order to make this possible.

    The expression doesnt work now and I have used different kinds of expression.

    Does anybody know how I can solve this or which type of expression I can use?

    The expression does only work when I take away Status from the dimension and from the dataset.

    Thanks for all help!

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply