reporting services - How to have a a single series data label on a grouped bar chart? -
i have ssrs bar chart shows data in handful of category groups. it's pretty straightforward , looks this:
i've got need segment each category 2 series groups so:
so far need display ungrouped percentage data labels (i.e. requirement continue show percentage of each combined category group, not percentage of series group). need bar chart second image data labels first.
for life of me cannot bar chart show series group data labels.
i had time ago. achieved by...
- creating second dataset fetched values wanted data labels
- selecting series in chart , in properties pane going labels, setting
usevalueaslabel = false
- setting "label" property lookup() fetched appropriate value second dataset
- using "visible" property hide labels 1 series no longer show.
the end result was:
hope makes sense!
edit: clarifying slightly: step 4 necessary because, you're finding, program apply label each series. other dataset fetches combined total, want hide labels 1 series avoid having same number repeated each of series.
Comments
Post a Comment