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
Try 2 use outer join n get all the weeks....so that wen there is no value the week will be displayed....
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