I have a column called Month that is formated as Date/Time, Format: 2001-03(yyyy-MM). It looks correct in the model. I have a line chart where I would like to have both Month and Year visible, since I have data spanning more than one year.
The problem is that my chart can only display Year OR Month. If I select both Year and Month in the date hierarchy, I only get Year displayed in the chart. Any ideas?