CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008-r2
Sam Bin Ham
Sam Bin Ham

Reputation: 449

How to hide zero values in SSRS stacked chart data labels

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.

"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

Tried the following,

=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) )

Sample Result

Upvotes: 1

Views: 2350

Answers (1)

niktrs
niktrs

Reputation: 10056

Right click on the chart series labels and select series label properties. In the number formatting, choose number and set Show zero as: to blank value

enter image description here

Upvotes: 4

Related Questions