Data label Expression

Question

G’day

We got the attached stacked bar chart,

The problem is the display of the data series. If the section is too small the value goes over the lines or the chart adds an arrow.

Is the a way to tidy this up for example only show a value if it’s above a certain threshold.

I tried this expression in the Visible property of one of the bars, but it didn’t seem to work?

=iif(Sum(Fields!EnglishValue.Value, "ChartData")>=5, True, False).

I guess it’s applying it across the entire series, but I want to evaluate each individual bar?

Any ideas.

Many thanks
Ron

Answer 1

Hi @ron barlow ,
Try the following expression:

=IIF(Sum(Fields!EnglishValue.Value)>=5,True,False)  

I did some tests locally to reproduce your issue, as shown below:

1. Create a stacked bar chart.
   
2. Select data labels. In the "Visible" option in the property bar, drop down and select the expression, enter: =IIF(Sum(Fields!Price.Value)>=15,true,false).
   
   
3. Preview
   
   After my test, the expression can successfully hide data labels less than 15.
   Best Regards,
   Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November

Answer 2

Hi @ron barlow ,
Has your issue been resolved?
If you have any question, please feel free to let me know.
If the answer is helpful, please click "Accept Answer" and upvote it.
Best Regards,
Joy