问题描述
我有一个SSRS条形图，显示少数类别组中的一些数据。它很简单，看起来像这样：
I have an SSRS bar chart the shows some data in a handful of category groups. It's pretty straightforward and looks like this:
我现在需要将每个类别分为两个系列组，如：
I've now got the need to segment each category into two series groups like so:
到目前为止很好，但是我需要显示未分组的百分比数据标签即要求是继续显示每个组合类别组的百分比，而不是系列组的百分比）。所以我需要第二个图像的条形图，但是第一个图像的数据标签。
So far so good however I need to display the ungrouped percentage data labels (i.e. the requirement is to continue to show the percentage of each combined category group, NOT the percentage of the series group). So I need the bar chart from the second image but the data labels from the first.
对于我的生活我不能得到条形图，组数据标签。
For the life of me I cannot get the bar chart to show anything but the series group data labels.
推荐答案
我不得不这么做。我最终实现了...
I had to do this some time ago. I eventually achieved it by...
- 创建第二个数据集，获取我想要的数据标签的值
- 在图表中选择系列，然后在属性窗格中转到标签，然后设置
UseValueAsLabel = False - 设置Label属性为从第二个数据集获取适当值的LookUp（）。
- 使用Visible属性隐藏一个系列的标签，
- Creating a second dataset that fetched the values I wanted for the Data Labels
- Selecting the Series in the Chart and in the Properties pane going to Labels, then setting
UseValueAsLabel = False - Setting the "Label" property to be a LookUp() that fetched the appropriate value from my second dataset
- Using the "Visible" property to hide the labels for one series so that they no longer show.
无法张贴图片，但最终结果是：
Can't post images yet, but the end result was: http://imgur.com/tUd8lBo
希望有意义！
编辑：澄清这一点：步骤4是必要的，因为，如果你发现，程序将应用一个标签到每个系列。另一个数据集获取组合总数，因此您要隐藏除一个系列之外的所有标签，以避免每个系列重复相同的数字。
Clarifying this slightly: step 4 is necessary because, as you're finding, the program will apply a label to each series. The other dataset fetches the combined total, so you want to hide the labels for all but one series to avoid having the same number repeated for each of the series.
这篇关于如何在组合的条形图上有单个系列数据标签？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！