Zero values missing on X axis despite using Master Calendar

[Anonymous]

I have used a master calendar to generate missing calendar months..

Missing months are appearing on the X axis as along as I uncheck 'Show All values' from the Dimensions tab

As a result even if I select specific few months to see the trend it shows all the months instead of the required months.

When i uncheck the 'Show all values' box the graph responds to the selection but the missing months dont appear.

Attached is my file.

[Anonymous]

Hi Sunny

I have a requirement very similar to the solution that you had provided in this thread using avg in the expression for showing the zero values. I have attached my qvw file.

I need to show trend of tickets and the line needs to touch zero wherever there is no value. This seems to be working fine with the expression that you had previously provided but when i put Application in the dimension along with Month it shows unnecessary application values that dont belong to the required Service Line in the legend and it gets shown as blank line in the graph.