Controling display labels
Hi, how can I control labels.visible property in expression for an specific series.
With this data:
Month
Type Value
1
1
5
1
2
9
1
3
3
2
1
10
2
2
15
2
3
4
I have a line chart with 3 lines with 3 value per month, I’m trying to display the labels values
just for the type = 1
How can I do that?
thanks
September 28th, 2011 9:44pm
Hi XavierSanchez,
Generally, we can right-click on the chart and select “Show Data Labels” to display the data labels. From your description, if you need to only display the data labels for “Type =1”, please refer to the following steps to achieve this:
1. Right-click on the data labels on the Line Chart and select “Series Label Properties”.
2. In the “Label data:” section, set the expression like this:
=IIF(Fields!Type.Value="1",Fields!Value.Value,Nothing)
The result show in the following figure:
If you have any more questions, please feel free to ask.
Thanks,
Bin Long
TechNet
Subscriber Supportin
forum
If you have any feedback on our support, please contact
tnmff@microsoft.comPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
September 29th, 2011 8:10am
thanks Bin Long, but it does not work, there are still all the label.
Let me explain little more about my chart.
Really It is a stacked bar chart with the same values I show above and after that I add an extra value series calculated (it is the type chart lines).
I’m talking about this line chart calculated, I understand the answer should be the same like you
said, but doesn’t work, may be my little explain makes a different answer.
Thanks a lot for your help
October 1st, 2011 1:25pm
thank you Bin Long, I found a mistake in my query, then you answer was exactly what I needed
thanks
Free Windows Admin Tool Kit Click here and download it now
October 1st, 2011 5:41pm