title: SSRS chart labels
body: <p>I need some help figuring out how to accurately display the labels in a stacked chart in SSRS; I need a single represenation of the upper stack in the below chart.</p>
  
  <p>The chart itself has two states, it can either be based on <strong>red</strong> or <strong>green</strong> data, both are in the same data source. </p>
  
  <p>At the moment the chart looks like this (this is based on green data):</p>
  
  <p><a href="https://i.stack.imgur.com/mtayI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mtayI.png" alt="enter image description here"></a></p>
  
  <p>As you can clearly see both the labels inside the chart and the legend is absolutely cluttered. The idea is to have a legend where we have two items (Late issues and Not finished issues); one that displays any non-finished issues and one that displays any non-finished issues that are outside the estimated due-date.</p>
  
  <p>For reference: The above chart should have 1 non-outstanding issue and 5 outstanding issues (3 Ongoing and 2 Open, see below for further info about stages).</p>
  
  <p><a href="https://i.stack.imgur.com/BoasG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BoasG.png" alt="enter image description here"></a></p>
  
  <p>Inside the chart we want to have a numerical respresentation of above requirements. Basically a number representing the outstanding issues and one that shows any non-finished issues.</p>
  
  <p>This is what a red representation looks like:</p>
  
  <p><a href="https://i.stack.imgur.com/CRBlx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CRBlx.png" alt="enter image description here"></a></p>
  
  <p>At this point I'm not sure what could be wrong anymore. As mentioned they both run on the same dataset, but with slightly different values.</p>
  
  <p>The red tracker has a simple True/False value that it runs most of its data from whereas the green tracker has a numerical representation of three values (5-7). Where the data it represent is: 5 - Open, 6 - Ongoing, 7 - Closed.</p>
  
  <p>I've attempted to only get the green data both when the series is either of the three above mentioned numbers, but also when it's only getting anything that is un-closed (5,6 but not 7). </p>
  
  <p>This is the code to set the labels for the maroon part of the chart (it's only a workable snippet.):</p>
  
  <pre><code>IIF(Count(IIF(Fields!Outstanding.Value = 1 AND 
  Fields!TRK_TrackerStatus_LKID2.Value &lt;&gt; 7, 1, Nothing)) = 0, "",
  Count(IIF(Fields!Outstanding.Value = 1  AND 
  Fields!TRK_TrackerStatus_LKID2.Value &lt;&gt; 7, 1, Nothing))))
  </code></pre>
  
  <p>Basically what it does is checking if there are more than 0 items that are outstanding and that aren't finished (are not 7). If there are more than 0, it sets the label. If there are 0 counted items, the label should be the empty string.</p>