Dynamic Label Positions With SSRS
On a recent tabular "dashboard" with several bar charts in a small area our team found vertical positioning of the labels to be troublesome. When the labels were set to "bottom" and the bar was too short the label would truncate the significant digits. On the other hand, when the labels were set to "top" the numbers would be truncated if the column was too tall. Example of bar chart with label set to bottom. Same chart with the middle column label set to top. First we thought about using Smart Labels but we quickly found that smart labels are not so smart when the labels are turned 90 degrees to make them vertical. As you can see in the examples above the size of the numbers would make horizontal labels messy. So the obvious choice was to use a function to place the label on top when the bar was small and on the bottom once the bar was tall enough. In Report Builder, go to your chart and select a specific column - not just the chart....