CODEWITHSUNDEEP
ssrs-2008pie-chart
Renu
Renu

Reputation: 81

SSRS Chart Hiding one group if it has 0 value

I have one pie chart that has 4 types. I want to hide the display of the particular group if the total aggregate is 0. Please see the attached image file. Based on my chart, Could anyone please help me how to change the filter condition not to show paid group if it has 0. TIA

Upvotes: 0

Views: 2569

Answers (2)

Eddie Kumar
Eddie Kumar

Reputation: 1480

Agree with Renu's approach (as in comments), just to elaborate, in order to suppress zero values (in data cells) use the IIF() function to return appropriate, i.e. right click the Data-Cell -> select Expression and enter something similar to the following expression::

    =IIF( Sum(Fields!columName.Value)=0, Nothing, Count(Fields!columName.Value) )

In case where you need to return a Boolean value (True/False), then use something similar to below:

    =IIF(Count(Fields!columName.Value)=0, False, True)

Upvotes: 0

Hannover Fist
Hannover Fist

Reputation: 10860

You can filter by TOTAL in the Category Group properties of the chart.

This is the only place in a chart where you can filter by an aggregate (SUM or COUNT).

enter image description here

Upvotes: 1

Related Questions