SSRS Column Chart with NULL dates

• gary.townsend

  Valued Member

  Points: 69

  More actions

  June 25, 2013 at 6:14 am

  #275589

  Hi All,

  I have a column chart which should show the totals of complaints over the last 6 months. My dataset returns the following:-

  YYYYMM Type Count

  2013-02 A 1

  2013-04 A 1

  2013-05 A 1

  Is it possible to show a chart with all 6 months labels but with a zero data point ?

  I've tried various combinations but nothing appears to work.

  Many thanks for your help.

  Gary