Graph Not to Show when Value =0 or No Data

[Bryan Doan]

Hello,

I have a graph with three series in it.  Each serie shows data from a column.  There are some months or all the months, depending on user selections, the data in one or all columns is 0.  How do I make the graphs not to show data when it is 0?  I tried to use IF in my calculated fields and put null if 0 and that worked but only worked when there's some data in the column, When the entire column had no data, an error "the column is not numeric" was thrown. 

Is there a way that not show the data when it is 0 even the entire column is 0? I just don't want the graph drops all the way to the bottom when 0.

Thanks!

[Peter]

Hi Bryan Doan,

By default the numeric data types are not nullable, thus the chart series cannot accept null as a value. In order to achieve this kind of customization our suggestion is to filter your chart data with the Filter or if this is not applicable for your scenario you can create the chart programmatically and achieve greater flexibility.

Greetings,
Peter
the Telerik team

[Bryan Doan]

Hi Peter,

Thanks for the response!  I found a solution for my case!