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!