5 Replies Latest reply: Mar 19, 2013 11:41 AM by Aldo Hernandez RSS

    Bar Chart with Static X Axis (Months)

      I have a table of data

       

      SalesGuyDateSales
      Person A1/1/2012

      59

      Person B1/2/201232
      Person C2/1/2012423
      Person A3/1/2012234

       

      etc

       

      I have a bar chart which shows the total sales for each month, with Month(Date) as the Dimension, and Sum(Sales) as an expression. It looks good!

       

      But I want this chart to change when i click a ListBox of my SalesGuys, so it shows the clicked persons sales. Problem is, if SalesGuy A doesnt sell anything in March, the months will redraw as JFAMJJASOND, when I want JFMAMJJASOND and 0 for March. Its not obvious that the month has been omitted.

       

      Hoe can I fix this, to force all months to be shown?

       

      I have tried "Show All Values" and Surpressing nulls etc with no luck.

       

      Thanks in advance.