Showing values of zero on charts

[jcasella]

I have a chart that counts the number of project (y-axis) vs the starting week(x-axis). So, for example the data  might look like this: Week of 6/2, 4 Projects Starting.   Week of 6/9, 0 Projects Starting.  Week of 6/16, 2 Projects Starting.

By default reportnet is only show weeks 6/2 and 6/16 on the chart, because they have values.  However I would like the chart to actually show me that the week of 6/9 as well, instead of interprelating that information myself.

Is this possible?

Thanks,
Josh

[mrcool]

Try 2 use outer join n get all the weeks....so that wen there is no value the week will be displayed....

[Darren12]

Hi,

If you're using a Tabular Model in the Tabular Data section of your query..you'll notice a property of the Tabular Model within the General section called Auto Group & Summarize..by default it is set to 'Yes'..turn this to 'No'..and make sure that the data used to populate the x-axis or the the points of the graph have a '0' value and not 'NULL' within the database ..I hope this helps..

Darren