title: How to hide zero values in SSRS stacked chart data labels
body: <p>I have a stacked bar chart, and some of the stacked values will display the data label for zero values, I have tried the many ways to hide the zero values in stacked chart data labels, But still displaying the Zero value bars.</p>
  
  <p>"Event_Type" resultsets from SQL query in Text format (ie: incident, Service Request , Problem and Change request etc ) and i am using count of those value to display in chart </p>
  
  <p>Tried the following,</p>
  
  <pre><code>=IIf(count(fields!Event_Type.Value) = 0, false, true)
  =IIF(First(Fields!Event_Type.Value, "DataSet1") Is Nothing, True, False)
  =IIF(count(Fields!Event_Type.Value, "DataSet1") = 0, True, False)
  =IIF( Sum(Fields!Event_Type.Value)=0, Nothing, Count(Fields!Event_Type.Value) )
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/jbGUn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jbGUn.png" alt="Sample Result"></a></p>