expression to display categories that dont have data in chart

hi ,

I'm using area chart to display my data in Yvalue i got 1,2,3,4,5 values and in x-axis category1,category2,etc.my requirement is if some categories won't have any data ...that category should show with 0 data,but currently only categories which having data are displaying

what is the expreession need to be written and where to be written.pls help

thanx in a

February 13th, 2015 1:20pm

Hi LuckyLucky12,

Based on my understanding, you are creating an area chart. If some categories dont have any data, you want to display 0 data for those categories.

In your scenario, we can use the IIF() function to judge if the category doesn't have any data,if the condition is right, then we can specify the Y-axis value display as 0 data . Please refer to our test results:

1. The same scenario as yours.

2. Specify the expression for Y-axis values like below, then preview the report.
=IIF(Fields!Num.Value is nothing,0,Fields!Num.Value)


If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
February 15th, 2015 9:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics